Deep Ghost (1984)

Little did Roy and Karen realize when they moved into their Hollywood "Dream Mansion" that it was haunted by Fred and Ginger, two of the horniest ghosts ever to come from the other side.