DBA Data[Home] [Help]

APPS.ARP_PROCESS_APPLICATION dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 1997: ar_receipt_method_accounts rma

1993: , l_payment_schedule_id
1994: , l_amount_due_remaining
1995: , l_amount_due_original
1996: FROM
1997: ar_receipt_method_accounts rma
1998: , ar_payment_schedules ps
1999: , ar_cash_receipts cr
2000: , ar_receivables_trx ed
2001: , ar_receivables_trx uned

Line 3471: , ar_receipt_method_accounts rma

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
3473: , ar_receivables_trx ed
3474: , ar_receivables_trx uned
3475: WHERE ps.payment_schedule_id = p_receipt_ps_id

Line 4910: l_onacc_cc_id ar_receipt_method_accounts.on_account_ccid%TYPE;

4906: l_amount_due_remaining NUMBER;
4907: ln_batch_id NUMBER;
4908: functional_curr VARCHAR2(100);
4909:
4910: l_onacc_cc_id ar_receipt_method_accounts.on_account_ccid%TYPE;
4911: l_unapp_cc_id ar_receipt_method_accounts.unapplied_ccid%TYPE;
4912:
4913: l_on_account_total NUMBER;
4914: l_ae_doc_rec ae_doc_rec_type;

Line 4911: l_unapp_cc_id ar_receipt_method_accounts.unapplied_ccid%TYPE;

4907: ln_batch_id NUMBER;
4908: functional_curr VARCHAR2(100);
4909:
4910: l_onacc_cc_id ar_receipt_method_accounts.on_account_ccid%TYPE;
4911: l_unapp_cc_id ar_receipt_method_accounts.unapplied_ccid%TYPE;
4912:
4913: l_on_account_total NUMBER;
4914: l_ae_doc_rec ae_doc_rec_type;
4915: l_prev_unapp_id NUMBER;

Line 4962: , ar_receipt_method_accounts rma

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
4964: AND cr.cash_receipt_id = ps.cash_receipt_id
4965: AND crh.cash_receipt_id = cr.cash_receipt_id
4966: AND crh.current_record_flag = 'Y'

Line 5476: ar_receipt_method_accounts rma,

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
5478: WHERE ps.payment_schedule_id = p_receipt_ps_id
5479: AND cr.cash_receipt_id = ps.cash_receipt_id
5480: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 6732: l_activity_cc_id ar_receipt_method_accounts.on_account_ccid%TYPE;

6728: l_amount_due_remaining NUMBER;
6729: ln_batch_id NUMBER;
6730: functional_curr VARCHAR2(100);
6731:
6732: l_activity_cc_id ar_receipt_method_accounts.on_account_ccid%TYPE;
6733: l_unapp_cc_id ar_receipt_method_accounts.unapplied_ccid%TYPE;
6734:
6735: l_on_account_total NUMBER;
6736: l_ae_doc_rec ae_doc_rec_type;

Line 6733: l_unapp_cc_id ar_receipt_method_accounts.unapplied_ccid%TYPE;

6729: ln_batch_id NUMBER;
6730: functional_curr VARCHAR2(100);
6731:
6732: l_activity_cc_id ar_receipt_method_accounts.on_account_ccid%TYPE;
6733: l_unapp_cc_id ar_receipt_method_accounts.unapplied_ccid%TYPE;
6734:
6735: l_on_account_total NUMBER;
6736: l_ae_doc_rec ae_doc_rec_type;
6737: l_prev_unapp_id NUMBER;

Line 6815: , ar_receipt_method_accounts rma

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
6817: WHERE ps.payment_schedule_id = p_receipt_ps_id
6818: AND cr.cash_receipt_id = ps.cash_receipt_id
6819: AND crh.cash_receipt_id = cr.cash_receipt_id