298: CURSOR c_get_country(p_site_use_id NUMBER) IS
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
327: loc.postal_code,
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