APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on HZ_PARTY_SITE_USES

Line 1149: from hz_party_site_uses

1145: s_status hz_cust_site_uses_all.status%TYPE := NULL;
1146:
1147: CURSOR l_primary_party_site_use_csr IS
1148: select primary_per_type
1149: from hz_party_site_uses
1150: where site_use_type = 'SHIP_TO'
1151: and primary_per_type = 'Y'
1152: and (party_site_id in
1153: (select party_site_id