APPS.AR_AUTOREC_API dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 2867: p_remittance_bank_account_id IN ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,

2863: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
2864: p_exchange_date IN ar_batches.exchange_date%TYPE,
2865: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
2866: p_currency_code IN VARCHAR2,
2867: p_remittance_bank_account_id IN ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,
2868: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
2869: p_return_status OUT NOCOPY VARCHAR2,
2870: p_msg_count OUT NOCOPY NUMBER,
2871: p_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 3888: l_remittance_bank_account_id ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE;

3884: l_cust_site_min_rec_amt NUMBER;
3885: l_rec_method_min_rec_amt NUMBER;
3886: l_min_rec_amount_allowed NUMBER;
3887: l_creation_method_code ar_receipt_classes.creation_method_code%type;
3888: l_remittance_bank_account_id ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE;
3889: l_state ar_receipt_classes.creation_status%TYPE;
3890: l_old_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
3891:
3892: l_paying_customer_id_array DBMS_SQL.NUMBER_TABLE;

Line 4046: ar_receipt_method_accounts rma,

4042: ar_cash_receipt_history crh,
4043: ar_payment_schedules ps,
4044: ra_cust_trx_types ctt,
4045: ar_payment_schedules inv_ps,
4046: ar_receipt_method_accounts rma,
4047: ar_receivables_trx ed,
4048: ar_receivables_trx uned,
4049: ar_open_trx_v ot,
4050: ar_receipts_gt rgt

Line 4321: from ar_receipt_method_accounts

4317: p_return_status => l_return_status);
4318:
4319: Select min_receipt_amount
4320: into l_rec_method_min_rec_amt
4321: from ar_receipt_method_accounts
4322: where receipt_method_id = p_receipt_method_id
4323: and remit_bank_acct_use_id = l_remittance_bank_account_id;
4324:
4325: EXCEPTION