APPS.CS_SERVICEREQUEST_PUB dependencies on HZ_PARTY_SITES

Line 6620: hz_party_sites hzp

6616: nvl2(loc.province, ','||loc.province,null) ||
6617: nvl2(loc.postal_code, ' '||loc.postal_code,null) ||
6618: nvl2(loc.country, ' '||loc.country,null)
6619: from hz_locations loc,
6620: hz_party_sites hzp
6621: where inc.incident_location_id = hzp.party_site_id
6622: and hzp.location_id = loc.location_id )
6623: ELSE inc.incident_address ||
6624: nvl2(inc.incident_city, ','||inc.incident_city,null) ||