APPS.JAI_ETCS_PKG dependencies on CE_BANK_BRANCHES_V

Line 2375: from ce_bank_branches_v a, ce_bank_accounts b

2371:
2372: -- Date 28/06/2007 by sacsethi for bug 6157120
2373: /* CURSOR c_bank_branch_code(cp_bank_account_id IN NUMBER) IS
2374: select a.branch_number
2375: from ce_bank_branches_v a, ce_bank_accounts b
2376: where a.branch_party_id = b.bank_branch_id
2377: and b.bank_account_id = cp_bank_account_id ;*/
2378:
2379: /*SELECT a.bank_num

Line 2385: v_bank_branch_code ce_bank_branches_v.BRANCH_NUMBER%TYPE;

2381: WHERE a.bank_branch_id = b.bank_branch_id
2382: AND b.bank_account_id = cp_bank_account_id;*/
2383:
2384: v_bank_account_id NUMBER(15);
2385: v_bank_branch_code ce_bank_branches_v.BRANCH_NUMBER%TYPE;
2386:
2387: lv_source_ref_type jai_rgm_refs_all.source_document_type%TYPE ;
2388: lv_doc_date date ;
2389: