UFN_FUNDINGREQUEST_GETTRANSACTIONAMOUNTAWARDED

            create function dbo.UFN_FUNDINGREQUEST_GETTRANSACTIONAMOUNTAWARDED
            (
                @FUNDINGREQUESTID uniqueidentifier
            )
            returns money
            with execute as caller
            as begin
            declare @GRANTAWARDAMOUNT money = 0;
            declare @WRITEOFFAMOUNT money = 0;

            select 
                @GRANTAWARDAMOUNT = sum(dbo.UFN_REVENUE_GETAMOUNTINCURRENCY(REVENUE.ID , FUNDINGREQUEST.TRANSACTIONCURRENCYID))                
            from 
                dbo.REVENUE
                inner join dbo.REVENUEFUNDINGREQUEST on REVENUE.ID = REVENUEFUNDINGREQUEST.ID
                inner join dbo.FUNDINGREQUEST ON FUNDINGREQUEST.ID = REVENUEFUNDINGREQUEST.FUNDINGREQUESTID
            where 
                REVENUEFUNDINGREQUEST.FUNDINGREQUESTID = @FUNDINGREQUESTID;

            select 
                @WRITEOFFAMOUNT = isnull(sum(dbo.UFN_INSTALLMENTSPLITWRITEOFF_GETAMOUNTINCURRENCY(REVENUE.ID ,FUNDINGREQUEST.TRANSACTIONCURRENCYID)), 0)

            from 
                dbo.INSTALLMENTSPLITWRITEOFF 
                inner join dbo.INSTALLMENTSPLIT on INSTALLMENTSPLITWRITEOFF.INSTALLMENTSPLITID = INSTALLMENTSPLIT.ID 
                inner join dbo.REVENUE on INSTALLMENTSPLIT.PLEDGEID = REVENUE.ID
                inner join dbo.REVENUEFUNDINGREQUEST on REVENUE.ID = REVENUEFUNDINGREQUEST.ID
                inner join dbo.FUNDINGREQUEST ON FUNDINGREQUEST.ID = REVENUEFUNDINGREQUEST.FUNDINGREQUESTID
            where 
                REVENUEFUNDINGREQUEST.FUNDINGREQUESTID = @FUNDINGREQUESTID;

            return isnull((@GRANTAWARDAMOUNT - @WRITEOFFAMOUNT),0)
        end