UFN_REMINDER_GETAMOUNTPAID

CREATE function dbo.UFN_REMINDER_GETAMOUNTPAID(
@REVENUEID uniqueidentifier,
@ASOFDATE datetime,
@TRANSACTIONTYPECODE tinyint
)
returns money
with execute as caller
as begin
    declare @TOTAL money

  if @TRANSACTIONTYPECODE = 2
  begin
      select @TOTAL = sum(RGIP.AMOUNT)
      from dbo.RECURRINGGIFTINSTALLMENTPAYMENT RGIP
      inner join dbo.RECURRINGGIFTINSTALLMENT RGI on RGI.ID = RGIP.RECURRINGGIFTINSTALLMENTID
      inner join dbo.FINANCIALTRANSACTION R on R.ID = RGIP.PAYMENTID
      where RGI.REVENUEID = @REVENUEID
      and R.DATE >= isnull(dbo.UFN_REMINDER_GETLASTREMINDERSENTDATE(@REVENUEID,2),R.DATE)
      and R.DATE < @ASOFDATE

      return @TOTAL
  end

  select @TOTAL = sum(ISP.AMOUNT)
  from dbo.INSTALLMENTSPLITPAYMENT ISP
  inner join dbo.INSTALLMENTSPLIT I on I.ID = ISP.INSTALLMENTSPLITID
  inner join dbo.FINANCIALTRANSACTIONLINEITEM RS on RS.ID = ISP.PAYMENTID
  inner join dbo.FINANCIALTRANSACTION R on R.ID = RS.FINANCIALTRANSACTIONID
  where ISP.PLEDGEID = @REVENUEID
  and R.DATE >= isnull(dbo.UFN_REMINDER_GETLASTREMINDERSENTDATE(@REVENUEID,1),R.DATE)
  and R.DATE < @ASOFDATE

  return @TOTAL
end