APPS.JAI_ETCS_PKG dependencies on CE_BANK_BRANCHES_V

Line 1944: from ce_bank_branches_v a, ce_bank_accounts b

1940:
1941: -- Date 28/06/2007 by sacsethi for bug 6157120
1942: /* CURSOR c_bank_branch_code(cp_bank_account_id IN NUMBER) IS
1943: select a.branch_number
1944: from ce_bank_branches_v a, ce_bank_accounts b
1945: where a.branch_party_id = b.bank_branch_id
1946: and b.bank_account_id = cp_bank_account_id ;*/
1947:
1948: /*SELECT a.bank_num

Line 1954: v_bank_branch_code ce_bank_branches_v.BRANCH_NUMBER%TYPE;

1950: WHERE a.bank_branch_id = b.bank_branch_id
1951: AND b.bank_account_id = cp_bank_account_id;*/
1952:
1953: v_bank_account_id NUMBER(15);
1954: v_bank_branch_code ce_bank_branches_v.BRANCH_NUMBER%TYPE;
1955:
1956: lv_source_ref_type jai_rgm_refs_all.source_document_type%TYPE ;
1957: lv_doc_date date ;
1958: