APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on HZ_LOCATIONS

Line 3376: hz_locations hz,

3372: CURSOR get_loc_for_site ( c_vendor_id NUMBER, c_vendor_site NUMBER) IS
3373: SELECT pvs.location_id, hzp.party_site_use_id
3374: FROM po_vendors pov,
3375: po_vendor_sites pvs,
3376: hz_locations hz,
3377: hz_party_site_uses hzp
3378: WHERE pov.vendor_id = pvs.vendor_id
3379: AND pvs.location_id = hz.location_id
3380: AND pov.vendor_id = c_vendor_id