USP_DATALIST_FUNDINGREQUESTS

Returns a list of funding requests for a given funding plan.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_FUNDINGREQUESTS
                (
                    @FUNDINGPLANID uniqueidentifier                
                )
                as
                    set nocount on;

                    select 
                        FUNDINGREQUEST.ID,
                        GRANTS.TITLE,
                        dbo.UFN_CONSTITUENT_BUILDNAME(GRANTS.GRANTORID),
                        (select dbo.UDA_BUILDLIST(dbo.UFN_DESIGNATION_GETNAME(FUNDINGREQUESTDESIGNATION.DESIGNATIONID)) from dbo.FUNDINGREQUESTDESIGNATION where FUNDINGREQUESTDESIGNATION.FUNDINGREQUESTID = FUNDINGREQUEST.ID) as DESIGNATIONS,
                        FUNDINGREQUEST.TRANSACTIONAMOUNTREQUESTED as AMOUNTREQUESTED,
                        FUNDINGREQUEST.TRANSACTIONAMOUNTAWARDED as AMOUNTAWARDED,
                        dbo.UFN_FUNDINGREQUESTSTATUSCODE_GETDESCRIPTION(FUNDINGREQUEST.FUNDINGREQUESTSTATUSCODEID) as STATUS,
                        dbo.UFN_FUNDINGREQUESTSTAGECODE_GETDESCRIPTION(FUNDINGREQUESTSTAGECODEID) as STAGE,
                        FUNDINGREQUEST.TRANSACTIONCURRENCYID as CURRENCYID
                    from 
                        dbo.FUNDINGREQUEST
                        inner join dbo.GRANTS on GRANTS.ID = FUNDINGREQUEST.GRANTSID
                    where 
                        FUNDINGREQUEST.FUNDINGPLANID = @FUNDINGPLANID