APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on HZ_PARTY_SITES

Line 800: hz_party_sites hps

796: SELECT asa.VENDOR_ID, aas.VENDOR_NAME
797: INTO X_SUPPLIER_ID, X_SUPPLIER_NAME
798: FROM ap_suppliers aas,
799: ap_supplier_sites_all asa,
800: hz_party_sites hps
801: WHERE hps.GLOBAL_LOCATION_NUMBER = X_EXT_SUP_ID
802: AND hps.party_site_id = asa.party_site_id
803: AND aas.vendor_id = asa.vendor_id
804: AND rownum = 1;

Line 812: hz_party_sites hps

808: SELECT asa.VENDOR_SITE_ID, asa.VENDOR_SITE_CODE
809: INTO X_SUPPLIER_ID, X_SUPPLIER_NAME
810: FROM ap_suppliers aas,
811: ap_supplier_sites_all asa,
812: hz_party_sites hps
813: WHERE hps.GLOBAL_LOCATION_NUMBER = X_EXT_SUP_ID
814: AND hps.party_site_id = asa.party_site_id
815: AND aas.vendor_id = asa.vendor_id
816: AND rownum = 1;