APPS.ZX_JA_EXTRACT_PKG dependencies on CE_BANK_BRANCHES_V

Line 2650: ce_bank_branches_v a

2646: a.bank_branch_name
2647: FROM zx_party_tax_profile ptp,
2648: xle_etb_profiles xlep,
2649: zx_registrations reg ,
2650: ce_bank_branches_v a
2651: WHERE ptp.party_id = xlep.party_id
2652: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
2653: AND xlep.legal_entity_id = P_TRL_GLOBAL_VARIABLES_REC.legal_entity_id
2654: AND xlep.main_establishment_flag = 'Y'

Line 2663: l_bank_name ce_bank_branches_v.bank_name%type;

2659: l_bank_id number;
2660: l_bank_branch_id number;
2661: l_account_id number;
2662: l_bank_account_num VARCHAR2(30);
2663: l_bank_name ce_bank_branches_v.bank_name%type;
2664: l_branch_name ce_bank_branches_v.bank_branch_name%type;
2665:
2666: l_count number;
2667: BEGIN

Line 2664: l_branch_name ce_bank_branches_v.bank_branch_name%type;

2660: l_bank_branch_id number;
2661: l_account_id number;
2662: l_bank_account_num VARCHAR2(30);
2663: l_bank_name ce_bank_branches_v.bank_name%type;
2664: l_branch_name ce_bank_branches_v.bank_branch_name%type;
2665:
2666: l_count number;
2667: BEGIN
2668: