OMG...It's The Ghost: XXX Parody (2012)

Molly and Sam's love for each other is like none other. It runs so deep that when Sam is murdered his spirit remains on earth to be with her. Along with the company of a shady psychic, they embark on a journey together that leads to some unworldly sex as well as the truth in Sam's untimely demise.