APPS.ECE_TRADING_PARTNERS_PUB dependencies on CE_BANK_BRANCHES_V

Line 275: FROM ce_bank_branches_v cbb,

271: cbb.country country,
272: TO_CHAR(NULL) region_1,
273: TO_CHAR(NULL) region_2,
274: TO_CHAR(NULL) region_3
275: FROM ce_bank_branches_v cbb,
276: hz_contact_points hcp,
277: hz_locations hzl,
278: hz_party_sites hps
279: WHERE NVL(UPPER(hcp.edi_ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND

Line 317: FROM ce_bank_branches_v cbb,

313: cbb.country country,
314: TO_CHAR(NULL) region_1,
315: TO_CHAR(NULL) region_2,
316: TO_CHAR(NULL) region_3
317: FROM ce_bank_branches_v cbb,
318: ece_tp_details etd,
319: hz_contact_points hcp,
320: hz_locations hzl,
321: hz_party_sites hps

Line 885: FROM ce_bank_branches_v cbb,

881: x_country_out,
882: x_region_1_out,
883: x_region_2_out,
884: x_region_3_out
885: FROM ce_bank_branches_v cbb,
886: hz_contact_points hcp,
887: hz_locations hzl,
888: hz_party_sites hps
889: WHERE cbb.branch_party_id = p_address_id_in AND

Line 2933: from ce_bank_branches_v cbb,

2929: and pvs.vendor_id = pv.vendor_id;
2930:
2931: cursor ap_bank is
2932: select cbb.branch_party_id
2933: from ce_bank_branches_v cbb,
2934: ece_tp_details etd,
2935: hz_contact_points hcp
2936: where
2937: etd.translator_code = p_translator_code

Line 3156: from ce_bank_branches_v cbb,

3152: and pvs.vendor_id = pv.vendor_id;
3153:
3154: cursor ap_bank is
3155: select cbb.bank_party_id address_id
3156: from ce_bank_branches_v cbb,
3157: ece_tp_headers eth,
3158: hz_contact_points hcp
3159: where
3160: eth.tp_reference_ext1 = p_reference_ext1

Line 3371: from ece_tp_headers ec, ce_bank_branches_v cbb,

3367: cursor ap_bank is
3368: select hcp.edi_ece_tp_location_code,
3369: ec.tp_reference_ext1,
3370: ec.tp_reference_ext2
3371: from ece_tp_headers ec, ce_bank_branches_v cbb,
3372: hz_contact_points hcp
3373: where
3374: cbb.branch_party_id = p_entity_address_id
3375: and hcp.edi_tp_header_id = ec.tp_header_id