UFN_FUNDINGREQUEST_GETAMOUNTAWARDED

            CREATE function dbo.UFN_FUNDINGREQUEST_GETAMOUNTAWARDED
            (
                @FUNDINGREQUESTID uniqueidentifier
            )
            returns money
            with execute as caller
            as begin

            declare @GRANTAWARDAMOUNT money = 0;            
            declare @WRITEOFFAMOUNT money = 0;
            declare @FUNDINGREQUESTBASECURRENCYID uniqueidentifier;

            select
                @FUNDINGREQUESTBASECURRENCYID = FUNDINGREQUEST.BASECURRENCYID
            from
                dbo.FUNDINGREQUEST
            where
                FUNDINGREQUEST.ID = @FUNDINGREQUESTID;

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

            select 
                @WRITEOFFAMOUNT = isnull(sum(dbo.UFN_INSTALLMENTSPLITWRITEOFF_GETAMOUNTINCURRENCY(REVENUE.ID ,@FUNDINGREQUESTBASECURRENCYID)), 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
            where 
                REVENUEFUNDINGREQUEST.FUNDINGREQUESTID = @FUNDINGREQUESTID;

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