UFN_ADDPROSPECTPLANSPROCESS_OPPORTUNITYDESIGNATIONS

Returns all opportunity designations 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_OPPORTUNITYDESIGNATIONS
            (
                @ADDPROSPECTPLANSPROCESSID uniqueidentifier
            )
            returns table 
            as return
                select 
                ID, 
                DESIGNATIONID, 
                AMOUNT, 
                SEQUENCE,
                FUNDINGMETHODCODEID,
                CATEGORYCODEID,
                TYPECODEID,
                USECODEID
                from 
                    dbo.ADDPROSPECTPLANSPROCESSOPPORTUNITYDESIGNATION
                where
                    ADDPROSPECTPLANSPROCESSID = @ADDPROSPECTPLANSPROCESSID;