APPS.POS_SUPPLIER_PUB_JOB_PKG dependencies on HZ_LOCATIONS

Line 83: FROM hz_locations hz,

79: WHERE aps.vendor_id = ap.vendor_id
80: AND aps.last_update_date BETWEEN l_from_date AND l_to_date
81: UNION
82: SELECT ap.party_id
83: FROM hz_locations hz,
84: ap_suppliers ap,
85: ap_supplier_sites_all ss
86: WHERE ss.vendor_id = ap.vendor_id
87: AND hz.location_id = ss.location_id