USP_DATALIST_FUNDINGREQUESTSPONSOR

Returns a list of secondary solicitors for a given funding request.

Parameters

Parameter	Parameter Type	Mode	Description
@FUNDINGREQUESTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_FUNDINGREQUESTSPONSOR
                    (
                        @FUNDINGREQUESTID uniqueidentifier
                    )
                    as
                        set nocount on;

                        select
                            FUNDINGREQUESTSPONSOR.ID,
                            NF.NAME,
                            dbo.UFN_FUNDINGREQUESTROLECODE_GETDESCRIPTION(FUNDINGREQUESTSPONSOR.FUNDINGREQUESTROLECODEID)
                        from 
                            dbo.FUNDINGREQUESTSPONSOR
                            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FUNDINGREQUESTSPONSOR.SPONSORID) NF
                        where
                            FUNDINGREQUESTSPONSOR.FUNDINGREQUESTID = @FUNDINGREQUESTID;