UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGESPLITGROSSAMOUNT

            CREATE function dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGESPLITGROSSAMOUNT
            (
                @PLEDGESPLITID uniqueidentifier
            )
            returns money
            with execute as caller
            as begin
                declare @PLEDGESPLITGROSSAMOUNT money

                select
                    @PLEDGESPLITGROSSAMOUNT = FINANCIALTRANSACTIONLINEITEM.BASEAMOUNT + coalesce(TAXCLAIM.BASETAXCLAIMAMOUNT + TAXCLAIM.TRANSITIONALTAXCLAIMAMOUNT, 0)
                from dbo.FINANCIALTRANSACTIONLINEITEM
                cross apply dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGETAXCLAIMAMOUNT(@PLEDGESPLITID) as TAXCLAIM
                where FINANCIALTRANSACTIONLINEITEM.ID = @PLEDGESPLITID

                return @PLEDGESPLITGROSSAMOUNT
            end