DBA Data[Home] [Help]

APPS.AR_BUS_EVENT_SUB_PVT dependencies on AR_CASH_RECEIPTS_ALL

Line 7244: FROM ar_cash_receipts_all cr,

7240: UPDATE ar_trx_bal_summary main_sum
7241: SET receipts_at_risk_value =
7242: (SELECT SUM(DECODE(rap.applied_payment_schedule_id, -2, 0,
7243: crh.amount))
7244: FROM ar_cash_receipts_all cr,
7245: ar_cash_receipt_history_all crh,
7246: ar_receivable_applications_all rap
7247: WHERE nvl(cr.confirmed_flag, 'Y') = 'Y'
7248: AND cr.reversal_date IS NULL

Line 7286: FROM ar_cash_receipts_all cr,

7282: UPDATE ar_trx_bal_summary main_sum
7283: SET receipts_at_risk_value = receipts_at_risk_value -
7284: (SELECT SUM(DECODE(rap.applied_payment_schedule_id, -2, 0,
7285: crh.amount))
7286: FROM ar_cash_receipts_all cr,
7287: ar_cash_receipt_history_all crh,
7288: ar_receivable_applications_all rap
7289: WHERE nvl(cr.confirmed_flag, 'Y') = 'Y'
7290: AND cr.reversal_date IS NULL