APPS.EC_TRADING_PARTNER_PVT dependencies on CE_BANK_BRANCHES_V

Line 60: from ce_bank_branches_v cbb,

56: and pvs.vendor_id = pv.vendor_id;
57:
58: cursor ap_bank is
59: select cbb.branch_party_id
60: from ce_bank_branches_v cbb,
61: ece_tp_details etd,
62: hz_contact_points hcp
63: where
64: etd.translator_code = p_translator_code

Line 303: from ce_bank_branches_v cbb,

299: and pvs.vendor_id = pv.vendor_id;
300:
301: cursor ap_bank is
302: select cbb.branch_party_id
303: from ce_bank_branches_v cbb,
304: ece_tp_headers eth,
305: hz_contact_points hcp
306: where
307: eth.tp_reference_ext1 = p_reference_ext1

Line 537: ce_bank_branches_v cbb,

533: select hcp.edi_ece_tp_location_code,
534: ec.tp_reference_ext1,
535: ec.tp_reference_ext2
536: from ece_tp_headers ec,
537: ce_bank_branches_v cbb,
538: hz_contact_points hcp
539: where
540: cbb.branch_party_id = p_entity_address_id
541: and hcp.edi_tp_header_id = ec.tp_header_id

Line 759: ce_bank_branches_v cbb,

755:
756: cursor type_bank is
757: select tpd.tp_detail_id
758: from ece_tp_details tpd,
759: ce_bank_branches_v cbb,
760: hz_contact_points hcp
761: where tpd.tp_header_id = hcp.edi_tp_header_id
762: and tpd.document_id = p_transaction_type
763: and tpd.document_type = nvl(p_transaction_subtype,tpd.document_type)