It’s a paranormal movie, probably made between 1995 and 2010. In this, ghosts of three former prostitutes lives in a house. In the house, there lives a couple. The wife is abusive to the husband. These ghosts takes over the body of the Wife in the night and have sex with the husband one by one. One of the prostitutes falls in love with the husband and vice-versa.
Paranormal Calamity (2010).
I hope this is it. If so, I’ve found it via IMDb keyword search: