Movie filmed in Charleston SC, mid80's - mid90's about a guy that dies and is in limbo and meets up with his old nanny from childhood -- they sing a popular song that has 'Soul' in the name and there is a cameo from some actress, Demi Moore I think. I just remember bits and pieces unfortunately... It seems like it had Heaven or Blue in the name

