299: SELECT
300: loc.country
301: FROM
302: hz_locations loc,
303: hz_party_sites ps,
304: hz_cust_acct_sites cas,
305: hz_cust_site_uses su
306: WHERE
307: ps.location_id = loc.location_id
328: loc.state,
329: loc.county
330: FROM
331: hz_locations loc,
332: hz_party_sites ps,
333: hz_cust_acct_sites cas,
334: hz_cust_site_uses su
335: WHERE
336: ps.location_id = loc.location_id