APPS.FUN_NET_ARAP_PKG dependencies on CE_BANKS_V

Line 3024: ce_banks_v ba

3020: p_le_id,
3021: p_bank_num
3022: FROM ce_bank_acct_uses ac_use,
3023: ce_bank_accounts ac,
3024: ce_banks_v ba
3025: WHERE ac.bank_account_id = g_bank_account_id
3026: AND ac.bank_account_id = ac_use.bank_account_id
3027: AND ac_use.org_id = g_batch_details.org_id
3028: AND ba.bank_party_id = ac.bank_id;

Line 3255: p_bank_num IN ce_banks_v.bank_number%TYPE,

3251: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
3252: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
3253: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
3254: p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
3255: p_bank_num IN ce_banks_v.bank_number%TYPE,
3256: x_return_status OUT NOCOPY VARCHAR2)
3257: IS
3258: l_vendor_name po_vendors.vendor_name%TYPE;
3259: l_vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE;

Line 3263: l_bank_num ce_banks_v.bank_number%TYPE;

3259: l_vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE;
3260: l_check_id ap_checks.check_id%TYPE;
3261: l_old_invoice ap_invoices.invoice_id%TYPE;
3262: amt_remaining ap_payment_schedules.amount_remaining%TYPE;
3263: l_bank_num ce_banks_v.bank_number%TYPE;
3264: -- Bug: 8537760
3265: l_amt_to_net fun_net_ap_invs.netted_amt%TYPE;
3266: l_applieddisc NUMBER;
3267: l_return_status VARCHAR2(1);

Line 4619: l_bank_num ce_banks_v.bank_number%TYPE;

4615: l_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
4616: l_bank_acct_name ce_bank_accounts.bank_account_name%TYPE;
4617: l_bank_acct_num ce_bank_accounts.bank_account_num%TYPE;
4618: l_le_id xle_entity_profiles.legal_entity_id%TYPE;
4619: l_bank_num ce_banks_v.bank_number%TYPE;
4620: batch_status_flag BOOLEAN;
4621: l_msg_data VARCHAR2(1000);
4622: l_msg_count NUMBER;
4623: -- txnCur txnCurType;