USP_DATALIST_GRANTFUNDINGREQUESTS

Returns a list of funding requests for a given grant.
Parameters

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

Copy


                CREATE procedure dbo.USP_DATALIST_GRANTFUNDINGREQUESTS
                (
                    @GRANTSID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        FUNDINGREQUEST.ID,
                        FUNDINGREQUEST.DATESUBMITTED,
                        FUNDINGREQUEST.TRANSACTIONAMOUNTREQUESTED as AMOUNTREQUESTED,
                        (select dbo.UDA_BUILDLIST(dbo.UFN_DESIGNATION_GETNAME(FUNDINGREQUESTDESIGNATION.DESIGNATIONID)) from dbo.FUNDINGREQUESTDESIGNATION where FUNDINGREQUESTDESIGNATION.FUNDINGREQUESTID = FUNDINGREQUEST.ID) as DESIGNATIONS,
                        FUNDINGPLAN.NAME,                        
                        dbo.UFN_CONSTITUENT_BUILDNAME(FUNDINGREQUEST.PRIMARYMANAGERID) as PRIMARYMANAGER,
                        dbo.UFN_CONSTITUENT_BUILDNAME(FUNDINGREQUEST.SECONDARYMANAGERID) as SECONDARYMANAGER,
                        dbo.UFN_FUNDINGREQUESTSTATUSCODE_GETDESCRIPTION(FUNDINGREQUEST.FUNDINGREQUESTSTATUSCODEID) as STATUS,
                        dbo.UFN_FUNDINGREQUESTSTAGECODE_GETDESCRIPTION(FUNDINGREQUEST.FUNDINGREQUESTSTAGECODEID) as STAGE,
                        FUNDINGREQUEST.TRANSACTIONCURRENCYID
                    from 
                        dbo.FUNDINGREQUEST
                        inner join dbo.FUNDINGPLAN on FUNDINGPLAN.ID = FUNDINGREQUEST.FUNDINGPLANID
                    where 
                        FUNDINGREQUEST.GRANTSID = @GRANTSID and
                        FUNDINGREQUEST.ID not in(select FUNDINGREQUESTID from dbo.REVENUEFUNDINGREQUEST)