APPS.CS_SERVICEREQUEST_PVT dependencies on HZ_LOCATIONS

Line 772: , hz_locations loc

768: SELECT
769: loc.timezone_id
770: FROM
771: hz_party_sites site
772: , hz_locations loc
773: WHERE site.location_id = loc.location_id
774: AND site.party_id = p_contact_party_id
775: AND site.identifying_address_flag = 'Y'
776: AND site.status = 'A';