The name of the movie is Clive Barker Presents Saint Sinner (2002).
In 1815 California, Father Michael, an emissary of Pope Pius VII, has traveled to meet with novice monk Brother Tomas. The young monk's order serves as the secret repository for evil, supernatural objects collected by the Church, and kept there for safekeeping. Michael delivers an ancient statue that has trapped two beautiful female demons, Munkar and Nakir. Tomas and his friend Brother Gregory inadvertently release the murderous demons, who travel to the 21st century using the monastery's Wheel of Time.
As his brother lies dying, he is given a chance to redeem himself by going through the Wheel of Time with a sacred dagger previously used by Saint Nicodemus to imprison the succubi. Tomas reluctantly intends to track down the evil creatures and destroy them. The young monk takes on the task, traveling through the Wheel only to discover a future world he does not understand in present-day Seattle, Washington, where he allies with police detective Rachel Dressler to recapture the homicidal terrors.
While the creatures seek to satisfy their centuries-long hunger, Tomas discovers their first victim. The police arrive on the murder scene and take Tomas into custody, believing he may be involved. Detective Rachel Dressler (Ravera) isn't about to believe Tomas' weird story, but strange things start to happen and bodies begin to pile up. Both Tomas and Rachel soon discover that the only way to stop these horrifying demons will be to take a leap of faith.