APPS.RCV_DEFAULT_PKG dependencies on HZ_PARTY_SITES

Line 767: FROM hz_party_sites hps,

763:
764: --Bug 5200786. Performace Issue. Added the last where condition
765: SELECT max(hps.location_id)
766: INTO x_ship_from_location_id
767: FROM hz_party_sites hps,
768: hz_party_site_uses hpsu,
769: po_vendor_sites_all pvs
770: WHERE pvs.vendor_site_id = p_vendor_site_id
771: AND hpsu.party_site_id = hps.party_site_id