USP_DATALIST_PROSPECTTEAMPROSPECTMANAGER

            CREATE procedure dbo.USP_DATALIST_PROSPECTTEAMPROSPECTMANAGER
            (
                @PROSPECTID uniqueidentifier
            )
            as
                set nocount on;

                declare @CURRENTDATEEARLIESTTIME datetime;
                set @CURRENTDATEEARLIESTTIME= dbo.UFN_DATE_GETEARLIESTTIME(getdate());

                select
                    PROSPECT.ID, 
                    PROSPECT.PROSPECTMANAGERFUNDRAISERID as MEMBERID, 
                    PROSPECTMANAGER_NF.NAME, 
                    'Prospect manager' as ROLEDESCRIPTION, 
                    PROSPECT.PROSPECTMANAGERSTARTDATE as DATEFROM, 
                    PROSPECT.PROSPECTMANAGERENDDATE as DATETO, 
                    dbo.UFN_FUNDRAISER_GETDEFAULTSITENAME(PROSPECT.PROSPECTMANAGERFUNDRAISERID) as ORGANIZATIONALSITE,                                
                    'Prospect manager - Current' as ROLETIMEFRAME
                from
                    dbo.PROSPECT
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PROSPECT.PROSPECTMANAGERFUNDRAISERID) PROSPECTMANAGER_NF
                where 
                    PROSPECT.ID = @PROSPECTID and
                    PROSPECT.PROSPECTMANAGERFUNDRAISERID is not null and
                    (
                        PROSPECT.PROSPECTMANAGERENDDATE is null or
                        PROSPECT.PROSPECTMANAGERENDDATE >= @CURRENTDATEEARLIESTTIME
                    )