UFN_FUNDINGREQUEST_GETSPONSORS

Gets the sponsors for a given funding request.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@FUNDINGREQUESTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_FUNDINGREQUEST_GETSPONSORS
            (
                @FUNDINGREQUESTID uniqueidentifier
            )
            returns table
            as
            return
                select
                    ID,
                    SPONSORID,
                    FUNDINGREQUESTROLECODEID
                from 
                    dbo.FUNDINGREQUESTSPONSOR
                where
                    FUNDINGREQUESTID = @FUNDINGREQUESTID