UFN_PLEDGE_GETAMOUNTPAID

CREATE function dbo.UFN_PLEDGE_GETAMOUNTPAID
(
  @PLEDGEID uniqueidentifier
) 
returns money
with execute as caller
as
begin
  declare @RESULT money;

  /*******************************************************************************/
  --NOTE: The following objects inline amount paid calculations, so any updates

  --to the way pledge paid amounts are calculated must be made in these as well.

  --

  --UFN_QUERY_PLEDGEREMINDEROUTPUT

  --UFN_QUERY_PLEDGEREMINDEROUTPUTDETAILS2

  --V_QUERY_PLEDGEREMINDERPROCESS

  --V_QUERY_PLEDGEREMINDERPROCESS_SEASONALADDRESSOUTPUT

  /*******************************************************************************/

  select @RESULT = 
    isnull((select
              sum (INSTALLMENTPAYMENT.AMOUNT)
            from dbo.INSTALLMENTPAYMENT
            inner join dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTIONLINEITEM.ID = INSTALLMENTPAYMENT.PAYMENTID
            inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
            inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
            inner join dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
            where INSTALLMENTPAYMENT.PLEDGEID = @PLEDGEID
            and FINANCIALTRANSACTION.DELETEDON is null
            and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
            and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1
           ), 0);

  return @RESULT;
end