UFN_WRITEOFF_GETINSTALLMENTSFOREDIT

CREATE function dbo.UFN_WRITEOFF_GETINSTALLMENTSFOREDIT (@WRITEOFFID uniqueidentifier)
returns table
as
return (
    select I.ID
      ,I.[DATE]
      ,I.AMOUNT
      ,BALANCE = (I.TRANSACTIONAMOUNT - I.AMOUNTPAID - I.AMOUNTWRITTENOFF) + isnull(INSTALLMENTWRITEOFFFOREDIT.TRANSACTIONAMOUNT,0)
      ,WRITEOFFAMOUNT = isnull(INSTALLMENTWRITEOFFFOREDIT.TRANSACTIONAMOUNT,0)
      ,I.SEQUENCE
      ,I.BASECURRENCYID
      ,I.ORGANIZATIONAMOUNT
      ,I.ORGANIZATIONEXCHANGERATEID
      ,I.TRANSACTIONAMOUNT
      ,I.TRANSACTIONCURRENCYID
      ,I.BASEEXCHANGERATEID
    from dbo.FINANCIALTRANSACTION WRITEOFF
    inner join dbo.UFN_INSTALLMENT_GETINFO_BULK() I on WRITEOFF.PARENTID = I.REVENUEID
    left join (
      select 
        INSTALLMENTWRITEOFF.TRANSACTIONAMOUNT,
        INSTALLMENTWRITEOFF.INSTALLMENTID
      from dbo.INSTALLMENTWRITEOFF
      where INSTALLMENTWRITEOFF.WRITEOFFID = @WRITEOFFID
    ) INSTALLMENTWRITEOFFFOREDIT on I.ID = INSTALLMENTWRITEOFFFOREDIT.INSTALLMENTID
    where 
      WRITEOFF.ID = @WRITEOFFID
      and WRITEOFF.DELETEDON is null
      and (I.TRANSACTIONAMOUNT - I.AMOUNTPAID) > 0
    )