UFN_GIFTAIDREVENUESPLIT_CALCULATESPLITGROSSAMOUNT_2

      CREATE function dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATESPLITGROSSAMOUNT_2
      (
      @ID uniqueidentifier,
      @ACTUALONLY bit,
      @CURRENCYCODE tinyint
      )
      returns money
      with execute as caller
      as begin
        declare @GROSSAMOUNT money;

        select @GROSSAMOUNT = case @CURRENCYCODE
                              when 0 then BASEAMOUNT
                              when 1 then TRANSACTIONAMOUNT
                              when 2 then ORGAMOUNT
                              end
        from dbo.FINANCIALTRANSACTIONLINEITEM
        inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
        where FINANCIALTRANSACTIONLINEITEM.ID = @ID
            and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
            and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1;

        set @GROSSAMOUNT = @GROSSAMOUNT + dbo.UFN_GIFTAIDREVENUESPLIT_GETSPLITTAXCLAIMAMOUNT_2(@ID, @ACTUALONLY,@CURRENCYCODE);

        return @GROSSAMOUNT;
      end