DBA Data[Home] [Help]

APPS.ARP_PROCESS_APPLICATION dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 2080: ar_receipt_method_accounts rma

2076: , l_payment_schedule_id
2077: , l_amount_due_remaining
2078: , l_amount_due_original
2079: FROM
2080: ar_receipt_method_accounts rma
2081: , ar_payment_schedules ps
2082: , ar_cash_receipts cr
2083: , ar_receivables_trx ed
2084: , ar_receivables_trx uned

Line 3644: , ar_receipt_method_accounts rma

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
3646: , ar_receivables_trx ed
3647: , ar_receivables_trx uned
3648: WHERE ps.payment_schedule_id = p_receipt_ps_id

Line 5253: l_onacc_cc_id ar_receipt_method_accounts.on_account_ccid%TYPE;

5249: l_amount_due_remaining NUMBER;
5250: ln_batch_id NUMBER;
5251: functional_curr VARCHAR2(100);
5252:
5253: l_onacc_cc_id ar_receipt_method_accounts.on_account_ccid%TYPE;
5254: l_unapp_cc_id ar_receipt_method_accounts.unapplied_ccid%TYPE;
5255:
5256: l_on_account_total NUMBER;
5257: l_ae_doc_rec ae_doc_rec_type;

Line 5254: l_unapp_cc_id ar_receipt_method_accounts.unapplied_ccid%TYPE;

5250: ln_batch_id NUMBER;
5251: functional_curr VARCHAR2(100);
5252:
5253: l_onacc_cc_id ar_receipt_method_accounts.on_account_ccid%TYPE;
5254: l_unapp_cc_id ar_receipt_method_accounts.unapplied_ccid%TYPE;
5255:
5256: l_on_account_total NUMBER;
5257: l_ae_doc_rec ae_doc_rec_type;
5258: l_prev_unapp_id NUMBER;

Line 5305: , ar_receipt_method_accounts rma

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
5307: AND cr.cash_receipt_id = ps.cash_receipt_id
5308: AND crh.cash_receipt_id = cr.cash_receipt_id
5309: AND crh.current_record_flag = 'Y'

Line 5824: ar_receipt_method_accounts rma,

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
5826: WHERE ps.payment_schedule_id = p_receipt_ps_id
5827: AND cr.cash_receipt_id = ps.cash_receipt_id
5828: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 7084: l_activity_cc_id ar_receipt_method_accounts.on_account_ccid%TYPE;

7080: l_amount_due_remaining NUMBER;
7081: ln_batch_id NUMBER;
7082: functional_curr VARCHAR2(100);
7083:
7084: l_activity_cc_id ar_receipt_method_accounts.on_account_ccid%TYPE;
7085: l_unapp_cc_id ar_receipt_method_accounts.unapplied_ccid%TYPE;
7086:
7087: l_on_account_total NUMBER;
7088: l_ae_doc_rec ae_doc_rec_type;

Line 7085: l_unapp_cc_id ar_receipt_method_accounts.unapplied_ccid%TYPE;

7081: ln_batch_id NUMBER;
7082: functional_curr VARCHAR2(100);
7083:
7084: l_activity_cc_id ar_receipt_method_accounts.on_account_ccid%TYPE;
7085: l_unapp_cc_id ar_receipt_method_accounts.unapplied_ccid%TYPE;
7086:
7087: l_on_account_total NUMBER;
7088: l_ae_doc_rec ae_doc_rec_type;
7089: l_prev_unapp_id NUMBER;

Line 7167: , ar_receipt_method_accounts rma

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
7169: WHERE ps.payment_schedule_id = p_receipt_ps_id
7170: AND cr.cash_receipt_id = ps.cash_receipt_id
7171: AND crh.cash_receipt_id = cr.cash_receipt_id