USP_DATALIST_NAMINGOPPORTUNITYPROSPECTS

Returns a list for all prospects for a naming opportunity

Parameters

Parameter	Parameter Type	Mode	Description
@NAMINGOPPORTUNITYID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@OPPORTUNITYSTATUSCODE	tinyint	IN	Plan opportunity status

Definition

Copy



                create procedure USP_DATALIST_NAMINGOPPORTUNITYPROSPECTS
                (
                    @NAMINGOPPORTUNITYID uniqueidentifier = null,
                    @OPPORTUNITYSTATUSCODE tinyint = 99
                )
                as
                    set nocount on;

                    if @OPPORTUNITYSTATUSCODE is null
                        set @OPPORTUNITYSTATUSCODE = 99;

                    select
                        PROSPECTPLANID,
                        PROSPECTNAME,
                        PLANTYPE,
                        PLANSTAGE,
                        PROSPECTMANAGER,
                        PRIMARYMANAGER,
                        SECONDARYMANAGER,
                        SECONDARYFUNDRAISERS,
                        PUBLICATIONDATE
                    from dbo.UFN_NAMINGOPPORTUNITY_ALLPROSPECTS(@NAMINGOPPORTUNITYID)
                    where
                        (@OPPORTUNITYSTATUSCODE = 99  or (@OPPORTUNITYSTATUSCODE = OPPORTUNITYSTATUSCODE))
                    order by PROSPECTNAME, PLANTYPE, PLANSTAGE, PUBLICATIONDATE;