[Home] [Help]
APPS.JG_JGZZRDLR_XMLP_PKG dependencies on AR_RECEIVABLE_APPLICATIONS
Line 457: AR_RECEIVABLE_APPLICATIONS ARA,
453: NVL(SUM(ARA.AMOUNT_APPLIED)
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