UFN_REVENUE_GETDEFAULTGIFTFEES

            CREATE function dbo.UFN_REVENUE_GETDEFAULTGIFTFEES(@REVENUEID uniqueidentifier)
            returns table
            AS            
            return 
            (
                select 
                    REVENUESPLIT.ID,
                    REVENUESPLIT.[APPLICATION],
                    REVENUESPLIT.AMOUNT,
                    dbo.UFN_PAYMENTAPPLICATION_GETDESCRIPTION(REVENUESPLIT.ID) DETAILS,
                    cast(coalesce(DEFAULTFEES.FEE, 0.00) as money) FEE,
                    cast(coalesce(DEFAULTFEES.WAIVED, 0) as bit) WAIVED
                from dbo.REVENUE
                inner join dbo.REVENUESPLIT
                    on REVENUE.ID = REVENUESPLIT.REVENUEID
                left outer join 
                    (select 
                        REVENUESPLITGIFTFEE.ID,
                        REVENUESPLITGIFTFEE.FEE FEE,
                        REVENUESPLITGIFTFEE.WAIVED WAIVED
                    from dbo.REVENUE REVSUB
                    cross apply dbo.UFN_REVENUE_GENERATEDEFAULTGIFTFEES(REVSUB.ID, REVSUB.CONSTITUENTID) REVENUESPLITGIFTFEE
                    where REVSUB.ID = @REVENUEID
                    ) DEFAULTFEES
                    on REVENUESPLIT.ID = DEFAULTFEES.ID
                where 
                    REVENUE.ID = @REVENUEID and
                    -- Exclude splits with an application of Order and type of Fee or Taxes since they aren't mapped

                    not (REVENUESPLIT.APPLICATIONCODE = 10 and (REVENUESPLIT.TYPECODE = 6 or REVENUESPLIT.TYPECODE = 7))
            )