APPS.ZX_JA_EXTRACT_PKG dependencies on CE_BANK_BRANCHES_V

Line 2577: ce_bank_branches_v a

2573: a.bank_branch_name
2574: FROM zx_party_tax_profile ptp,
2575: xle_etb_profiles xlep,
2576: zx_registrations reg ,
2577: ce_bank_branches_v a
2578: WHERE ptp.party_id = xlep.party_id
2579: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
2580: AND xlep.legal_entity_id = P_TRL_GLOBAL_VARIABLES_REC.legal_entity_id
2581: AND xlep.main_establishment_flag = 'Y'

Line 2590: l_bank_name ce_bank_branches_v.bank_name%type;

2586: l_bank_id number;
2587: l_bank_branch_id number;
2588: l_account_id number;
2589: l_bank_account_num VARCHAR2(30);
2590: l_bank_name ce_bank_branches_v.bank_name%type;
2591: l_branch_name ce_bank_branches_v.bank_branch_name%type;
2592:
2593: l_count number;
2594: BEGIN

Line 2591: l_branch_name ce_bank_branches_v.bank_branch_name%type;

2587: l_bank_branch_id number;
2588: l_account_id number;
2589: l_bank_account_num VARCHAR2(30);
2590: l_bank_name ce_bank_branches_v.bank_name%type;
2591: l_branch_name ce_bank_branches_v.bank_branch_name%type;
2592:
2593: l_count number;
2594: BEGIN
2595: