USP_DATALIST_GRANTAWARDBYGRANT

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

                    select distinct
                        REVENUE.ID,
                        REVENUE.DATE,
                        FUNDINGREQUEST.TRANSACTIONAMOUNTREQUESTED as AMOUNTREQUESTED,
                        REVENUE.TRANSACTIONAMOUNT as AMOUNT,
                        dbo.UFN_PLEDGE_GETBALANCE(REVENUE.ID) as BALANCE,
                        (select dbo.UDA_BUILDLIST(dbo.UFN_DESIGNATION_GETNAME(REVENUESPLIT.DESIGNATIONID)) from dbo.REVENUESPLIT inner join dbo.REVENUEFUNDINGREQUEST RFQ on RFQ.ID = REVENUESPLIT.REVENUEID and RFQ.ID = REVENUEFUNDINGREQUEST.ID) as DESIGNATIONS,
                        FUNDINGPLAN.NAME,
                        PRIMARYMANAGER_NF.NAME as PRIMARYMANAGER,
                        SECONDARYMANAGER_NF.NAME as SECONDARYMANAGER,
                        FUNDINGREQUEST.ID as FUNDINGREQUESTID,
                        FUNDINGREQUEST.TRANSACTIONCURRENCYID,
                        REVENUE.TRANSACTIONCURRENCYID as REVENUETRANSACTIONCURRENCYID
                    from
                        dbo.REVENUEFUNDINGREQUEST
                        inner join dbo.REVENUE on REVENUEFUNDINGREQUEST.ID = REVENUE.ID
                        left join dbo.FUNDINGREQUEST on FUNDINGREQUEST.ID = REVENUEFUNDINGREQUEST.FUNDINGREQUESTID
                        left join dbo.FUNDINGPLAN on FUNDINGPLAN.ID = FUNDINGREQUEST.FUNDINGPLANID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FUNDINGREQUEST.PRIMARYMANAGERID) PRIMARYMANAGER_NF
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FUNDINGREQUEST.SECONDARYMANAGERID) SECONDARYMANAGER_NF
                    where
                        FUNDINGREQUEST.GRANTSID = @GRANTSID
                    order by FUNDINGPLAN.NAME asc;