2154: SELECT hzloc.country
2155: FROM hz_cust_site_uses_all hzcsua,
2156: hz_cust_acct_sites_all hzcasa,
2157: hz_locations hzloc,
2158: hz_party_sites hzps
2159: WHERE hzcsua.cust_acct_site_id = hzcasa.cust_acct_site_id
2160: AND hzcasa.party_site_id = hzps.party_site_id
2161: AND hzps.location_id = hzloc.location_id
2162: AND hzcsua.status = 'A'