APPS.ARP_PROCESS_APPLICATION dependencies on AR_CASH_RECEIPT_HISTORY

Line 497: ar_cash_receipt_history crh

493: crh.batch_id
494: INTO
495: ln_batch_id
496: FROM
497: ar_cash_receipt_history crh
498: , ar_receivable_applications ra
499: WHERE
500: ra.receivable_application_id = p_ra_id
501: AND ra.cash_receipt_id = crh.cash_receipt_id

Line 2500: FROM AR_CASH_RECEIPT_HISTORY crh

2496: INTO l_dummy
2497: FROM dual
2498: WHERE EXISTS
2499: ( SELECT 1
2500: FROM AR_CASH_RECEIPT_HISTORY crh
2501: WHERE crh.cash_receipt_id = l_ra_rec.application_ref_id
2502: AND crh.status IN ('REMITTED', 'CLEARED'));
2503: EXCEPTION
2504: WHEN NO_DATA_FOUND THEN

Line 3641: , ar_cash_receipt_history crh

3637: , l_maturity_date
3638: , l_amount_applied
3639: , l_org_id
3640: FROM ar_cash_receipts cr
3641: , ar_cash_receipt_history crh
3642: , ar_receipt_methods rm
3643: , ce_bank_acct_uses_ou ba
3644: , ar_receipt_method_accounts rma
3645: , ar_payment_schedules ps

Line 5302: , ar_cash_receipt_history crh

5298: l_unapp_cc_id
5299: , ln_batch_id
5300: FROM ar_payment_schedules ps
5301: , ar_cash_receipts cr
5302: , ar_cash_receipt_history crh
5303: , ar_receipt_methods rm
5304: , ce_bank_acct_uses ba
5305: , ar_receipt_method_accounts rma
5306: WHERE ps.payment_schedule_id = p_receipt_ps_id

Line 5821: ar_cash_receipt_history crh,

5817: rt.code_combination_id activity_ccid,
5818: rt.type activity_type
5819: FROM ar_payment_schedules ps,
5820: ar_cash_receipts cr,
5821: ar_cash_receipt_history crh,
5822: ar_receipt_methods rm,
5823: ce_bank_acct_uses ba,
5824: ar_receipt_method_accounts rma,
5825: ar_receivables_trx rt

Line 7164: , ar_cash_receipt_history crh

7160: , l_receipt_number
7161: , l_legal_entity_id
7162: FROM ar_payment_schedules ps
7163: , ar_cash_receipts cr
7164: , ar_cash_receipt_history crh
7165: , ar_receipt_methods rm
7166: , ce_bank_acct_uses ba
7167: , ar_receipt_method_accounts rma
7168: , ar_receivables_trx rt