UFN_PROSPECTPLAN_PARTICIPANTS

            CREATE function dbo.UFN_PROSPECTPLAN_PARTICIPANTS
      (
        @PROSPECTPLANID uniqueidentifier
      ) 
      returns table
        as return
            select
            PP.ID, PP.CONSTITUENTID, PP.PLANPARTICIPANTROLECODEID, NF.NAME, PPRC.DESCRIPTION as PLANPARTICIPANTROLECODE
          from 
            dbo.PLANPARTICIPANT as PP
            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PP.CONSTITUENTID) NF
            left outer join dbo.PLANPARTICIPANTROLECODE as PPRC on PP.PLANPARTICIPANTROLECODEID = PPRC.ID
            where PP.PROSPECTPLANID=@PROSPECTPLANID