filming location of church used in film

I was curious as to where the interior scnes of the church that was used not only in the opening scene but also in the confession scenes as well is located. I am assuming it is in Brooklyn but it could have been shot somewhere else in New York City. I know it was not shot at St Michael's Catholic church in Sunset Park, Brooklyn, where the rest of the movie was made because I have been inside the church and it looks nothing like the one in the film. Anyone know?