APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on HZ_PARTY_SITE_USES

Line 668: from hz_party_site_uses

664: s_status hz_cust_site_uses_all.status%TYPE := NULL;
665:
666: CURSOR l_primary_party_site_use_csr IS
667: select primary_per_type
668: from hz_party_site_uses
669: where site_use_type = 'SHIP_TO'
670: and primary_per_type = 'Y'
671: and (party_site_id in
672: (select party_site_id