UFN_ADDPROSPECTPLANSPROCESS_SECONDARYFUNDRAISERS

Returns all secondary fundraisers for a given Add Prospect Plans process instance.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ADDPROSPECTPLANSPROCESSID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_ADDPROSPECTPLANSPROCESS_SECONDARYFUNDRAISERS
            (
                @ADDPROSPECTPLANSPROCESSID uniqueidentifier
            )
            returns table 
            as return
                select 
                    ID, 
                    FUNDRAISERID, 
                    SOLICITORROLECODEID, 
                    SEQUENCE
                from 
                    dbo.ADDPROSPECTPLANSPROCESSSECONDARYFUNDRAISER
                where
                    ADDPROSPECTPLANSPROCESSID = @ADDPROSPECTPLANSPROCESSID;