USP_SIMPLEDATALIST_FUNDRAISERPROSPECTS

                CREATE procedure dbo.USP_SIMPLEDATALIST_FUNDRAISERPROSPECTS
                (
                    @FUNDRAISERID uniqueidentifier
                )
                as
                set nocount on;

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


                    select distinct
                        PROSPECT.ID as 'VALUE',
                        NF.NAME as 'LABEL'
                    from dbo.PROSPECT
                        inner join dbo.PROSPECTPLAN on PROSPECT.ID = PROSPECTPLAN.PROSPECTID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PROSPECT.ID) NF
                    where
                        PROSPECT.PROSPECTMANAGERFUNDRAISERID = @FUNDRAISERID
                        or PROSPECTPLAN.PRIMARYMANAGERFUNDRAISERID = @FUNDRAISERID
                        or PROSPECTPLAN.SECONDARYMANAGERFUNDRAISERID = @FUNDRAISERID