APPS.AR_BR_REMIT_IMPORT_API_PUB dependencies on CE_BANK_ACCT_USES

Line 159: l_remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;

155: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
156: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE
157: ) IS
158:
159: l_remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
160: l_currency_code ar_batches.currency_code%TYPE;
161: l_gl_date ar_batches.gl_date%type;
162: l_with_recourse_flag ar_batches.with_recourse_flag%TYPE;
163: l_batch_date ar_batches.batch_date%TYPE;

Line 207: ce_bank_acct_uses cbau

203:
204:
205: SELECT cba.bank_account_num INTO l_bank_account_num
206: FROM ce_bank_accounts cba,
207: ce_bank_acct_uses cbau
208: WHERE cbau.bank_acct_use_id =l_remit_bank_acct_use_id
209: AND cbau.bank_account_id = cba.bank_account_id;
210:
211: If l_bank_account_num <> p_remittance_bnk_acct_number THEN

Line 418: l_remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;

414: l_reserved_value ar_payment_schedules.reserved_value%TYPE;
415: l_batch_id ar_batches.batch_id%TYPE := null;
416: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
417: l_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;
418: l_remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
419: l_media_reference ar_batches.media_reference%TYPE;
420:
421: x_batch_id ar_batches.batch_id%TYPE;
422: x_batch_applied_status ar_batches.batch_applied_status%TYPE;

Line 434: FROM ce_bank_accounts cba, ce_bank_acct_uses cbau

430: CURSOR account (p_branch_id NUMBER,
431: p_bank_account_number NUMBER,
432: p_currency_code VARCHAR2) IS
433: SELECT cbau.bank_acct_use_id
434: FROM ce_bank_accounts cba, ce_bank_acct_uses cbau
435: WHERE cba.bank_account_id = cbau.bank_account_id
436: AND cba.bank_branch_id = p_branch_id
437: AND cba.bank_account_num = p_bank_account_number
438: AND cba.currency_code = p_currency_code