454: ,0)
455: INTO L_AMOUNT
456: FROM
457: AR_RECEIVABLE_APPLICATIONS ARA,
458: AR_CASH_RECEIPTS RPT,
459: AR_CASH_RECEIPT_HISTORY RTPH
460: WHERE ARA.APPLIED_CUSTOMER_TRX_ID = TRX_ID
461: AND ARA.CASH_RECEIPT_ID = RPT.CASH_RECEIPT_ID
462: AND RPT.CASH_RECEIPT_ID = RTPH.CASH_RECEIPT_ID