In Generation II:
Sleep Talk randomly chooses one of the user's moves other than Sleep Talk itself and uses it. PP will be deducted from Sleep Talk only, which means that it can be used to execute moves that have no PP left.
In later generations:
Sleep Talk can call a move with no PP remaining, but will fail to execute it due to a lack of PP.
Sleep Talk (Bulbapedia)