UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGEGROSSAMOUNT

            CREATE function dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGEGROSSAMOUNT
            (
                @PLEDGEID uniqueidentifier
            )
            returns money
            with execute as caller
            as begin
                declare @PLEDGEGROSSAMOUNT money

                select
                    @PLEDGEGROSSAMOUNT = sum(REVENUESPLIT.AMOUNT) + sum(coalesce(TAXCLAIM.BASETAXCLAIMAMOUNT + TAXCLAIM.TRANSITIONALTAXCLAIMAMOUNT, 0))
                from dbo.REVENUESPLIT
                cross apply dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGETAXCLAIMAMOUNT(REVENUESPLIT.ID) as TAXCLAIM
                where REVENUESPLIT.REVENUEID = @PLEDGEID

                return @PLEDGEGROSSAMOUNT
            end