UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGEGROSSAMOUNT_2

            CREATE function dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGEGROSSAMOUNT_2
            (
                @PLEDGEID uniqueidentifier,
        @CURRENCYTYPE tinyint
            )
            returns money
            with execute as caller
            as begin
                declare @PLEDGEGROSSAMOUNT money
                declare @REVENUESPLITAMOUNT money  
                select
                    @PLEDGEGROSSAMOUNT = case @CURRENCYTYPE when 0 then sum(FINANCIALTRANSACTIONLINEITEM.BASEAMOUNT)
                                                  when 1 then sum(FINANCIALTRANSACTIONLINEITEM.TRANSACTIONAMOUNT)
                                                  when 2 then sum(FINANCIALTRANSACTIONLINEITEM.ORGAMOUNT)
                                                  end 
         + sum(coalesce(TAXCLAIM.BASETAXCLAIMAMOUNT + TAXCLAIM.TRANSITIONALTAXCLAIMAMOUNT, 0))
                from dbo.FINANCIALTRANSACTIONLINEITEM
                inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
                cross apply dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGETAXCLAIMAMOUNT_2(FINANCIALTRANSACTIONLINEITEM.ID,@CURRENCYTYPE) as TAXCLAIM
                where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @PLEDGEID
                    and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
                    and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1

                return @PLEDGEGROSSAMOUNT
            end