APPS.WSH_ROUTING_REQUEST dependencies on HZ_PARTY_SITES

Line 2471: FROM hz_party_sites ps,hz_party_site_uses psu

2467: --Code.
2468: CURSOR check_location_csr(cp_party_id NUMBER,
2469: cp_location_code VARCHAR2) IS
2470: SELECT ps.location_id,ps.party_site_id,ps.party_id,ps.status -- IB-Phase-2 Vendor Merge
2471: FROM hz_party_sites ps,hz_party_site_uses psu
2472: WHERE ps.party_site_id = psu.party_site_id
2473: AND psu.site_use_type = 'SUPPLIER_SHIP_FROM'
2474: and party_site_number=cp_location_code
2475: and party_id =cp_party_id;