UFN_FUNDINGREQUEST_GETORGANIZATIONAMOUNTAWARDED

    create function dbo.UFN_FUNDINGREQUEST_GETORGANIZATIONAMOUNTAWARDED
   (
                @FUNDINGREQUESTID uniqueidentifier
            ) 
            returns money
            with execute as caller
            as begin

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

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

                select 
                    @WRITEOFFAMOUNT = isnull(sum(INSTALLMENTSPLITWRITEOFF.ORGANIZATIONAMOUNT), 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