APPS.FUN_NET_ARAP_PKG dependencies on CE_BANKS_V

Line 2339: ce_banks_v ba

2335: p_le_id,
2336: p_bank_num
2337: FROM ce_bank_acct_uses ac_use,
2338: ce_bank_accounts ac,
2339: ce_banks_v ba
2340: WHERE ac.bank_account_id = g_bank_account_id
2341: AND ac.bank_account_id = ac_use.bank_account_id
2342: AND ac_use.org_id = g_batch_details.org_id
2343: AND ba.bank_party_id = ac.bank_id;

Line 2573: p_bank_num IN ce_banks_v.bank_number%TYPE,

2569: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
2570: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
2571: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
2572: p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
2573: p_bank_num IN ce_banks_v.bank_number%TYPE,
2574: x_return_status OUT NOCOPY VARCHAR2)
2575: IS
2576: l_vendor_name po_vendors.vendor_name%TYPE;
2577: l_vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE;

Line 2581: l_bank_num ce_banks_v.bank_number%TYPE;

2577: l_vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE;
2578: l_check_id ap_checks.check_id%TYPE;
2579: l_old_invoice ap_invoices.invoice_id%TYPE;
2580: amt_remaining ap_payment_schedules.amount_remaining%TYPE;
2581: l_bank_num ce_banks_v.bank_number%TYPE;
2582: l_return_status VARCHAR2(1);
2583: m integer;
2584: l_path VARCHAR2(100);
2585: l_gl_date date; -- Bug: 7639863

Line 3963: l_bank_num ce_banks_v.bank_number%TYPE;

3959: l_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
3960: l_bank_acct_name ce_bank_accounts.bank_account_name%TYPE;
3961: l_bank_acct_num ce_bank_accounts.bank_account_num%TYPE;
3962: l_le_id xle_entity_profiles.legal_entity_id%TYPE;
3963: l_bank_num ce_banks_v.bank_number%TYPE;
3964: batch_status_flag BOOLEAN;
3965: l_msg_data VARCHAR2(1000);
3966: l_msg_count NUMBER;
3967: -- txnCur txnCurType;