APPS.CSD_PARTIES_UTIL dependencies on HZ_PARTY_SITES

Line 172: FROM hz_party_sites sites, hz_locations loc

168: SELECT loc.location_id,
169: loc.last_update_date,
170: sites.party_site_id,
171: sites.last_update_date sites_last_update_date
172: FROM hz_party_sites sites, hz_locations loc
173: WHERE sites.party_id = l_party_id
174: AND loc.location_id = sites.location_id
175: AND sites.identifying_address_flag='Y' ;
176: