USP_DATALIST_GRANTAWARD

Returns a list of grant awards 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_GRANTAWARD
                (
                    @FUNDINGREQUESTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        REVENUE.ID,
                        dbo.UFN_CONSTITUENT_BUILDNAME(REVENUE.CONSTITUENTID) as CONSTITUENTNAME,
                        REVENUE.DATE,
                        REVENUE.TRANSACTIONAMOUNT,
                        dbo.UFN_PLEDGE_GETBALANCE(REVENUE.ID) as BALANCE,
                        REVENUE.TRANSACTIONCURRENCYID
                    from 
                        dbo.REVENUEFUNDINGREQUEST
                        inner join dbo.REVENUE on REVENUEFUNDINGREQUEST.ID = REVENUE.ID
                    where 
                        REVENUEFUNDINGREQUEST.FUNDINGREQUESTID = @FUNDINGREQUESTID;