APPS.ARP_PROCESS_APPLICATION dependencies on AR_CASH_RECEIPT_HISTORY

Line 468: ar_cash_receipt_history crh

464: crh.batch_id
465: INTO
466: ln_batch_id
467: FROM
468: ar_cash_receipt_history crh
469: , ar_receivable_applications ra
470: WHERE
471: ra.receivable_application_id = p_ra_id
472: AND ra.cash_receipt_id = crh.cash_receipt_id

Line 2412: FROM AR_CASH_RECEIPT_HISTORY crh

2408: INTO l_dummy
2409: FROM dual
2410: WHERE EXISTS
2411: ( SELECT 1
2412: FROM AR_CASH_RECEIPT_HISTORY crh
2413: WHERE crh.cash_receipt_id = l_ra_rec.application_ref_id
2414: AND crh.status IN ('REMITTED', 'CLEARED'));
2415: EXCEPTION
2416: WHEN NO_DATA_FOUND THEN

Line 3468: , ar_cash_receipt_history crh

3464: , l_inv_ra_rec.earned_discount_ccid
3465: , l_inv_ra_rec.unearned_discount_ccid
3466: , ln_batch_id
3467: FROM ar_cash_receipts cr
3468: , ar_cash_receipt_history crh
3469: , ar_receipt_methods rm
3470: , ce_bank_acct_uses_ou ba
3471: , ar_receipt_method_accounts rma
3472: , ar_payment_schedules ps

Line 4959: , ar_cash_receipt_history crh

4955: l_unapp_cc_id
4956: , ln_batch_id
4957: FROM ar_payment_schedules ps
4958: , ar_cash_receipts cr
4959: , ar_cash_receipt_history crh
4960: , ar_receipt_methods rm
4961: , ce_bank_acct_uses ba
4962: , ar_receipt_method_accounts rma
4963: WHERE ps.payment_schedule_id = p_receipt_ps_id

Line 5473: ar_cash_receipt_history crh,

5469: rt.code_combination_id activity_ccid,
5470: rt.type activity_type
5471: FROM ar_payment_schedules ps,
5472: ar_cash_receipts cr,
5473: ar_cash_receipt_history crh,
5474: ar_receipt_methods rm,
5475: ce_bank_acct_uses ba,
5476: ar_receipt_method_accounts rma,
5477: ar_receivables_trx rt

Line 6812: , ar_cash_receipt_history crh

6808: , l_receipt_number
6809: , l_legal_entity_id
6810: FROM ar_payment_schedules ps
6811: , ar_cash_receipts cr
6812: , ar_cash_receipt_history crh
6813: , ar_receipt_methods rm
6814: , ce_bank_acct_uses ba
6815: , ar_receipt_method_accounts rma
6816: , ar_receivables_trx rt