UFN_PROSPECTPLANVIEW_SECONDARYFUNDRAISERS

            CREATE function dbo.UFN_PROSPECTPLANVIEW_SECONDARYFUNDRAISERS(@PROSPECTPLANID uniqueidentifier)
            returns table 
            as return
                select 
                    SECONDARYFUNDRAISER.ID, 
                    SECONDARYFUNDRAISER.FUNDRAISERID, 
                    SECONDARYFUNDRAISER.SOLICITORROLECODEID,
                    SECONDARYFUNDRAISER.SEQUENCE,
                    NF.NAME as FUNDRAISERNAME,
                    SOLICITORROLECODE.DESCRIPTION as ROLE,
                    CONSTITUENT.KEYNAME,
                    CONSTITUENT.FIRSTNAME
                from dbo.SECONDARYFUNDRAISER
                inner join dbo.CONSTITUENT on SECONDARYFUNDRAISER.FUNDRAISERID = CONSTITUENT.ID
                left join dbo.SOLICITORROLECODE on SECONDARYFUNDRAISER.SOLICITORROLECODEID = SOLICITORROLECODE.ID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                where PROSPECTPLANID=@PROSPECTPLANID
                AND (SECONDARYFUNDRAISER.DATETO is null OR SECONDARYFUNDRAISER.DATETO >= dbo.UFN_DATE_GETEARLIESTTIME(getdate()))