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
308: and cas.party_site_id = ps.party_site_id
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
337: and cas.party_site_id = ps.party_site_id
344: CURSOR c_get_cust_account(p_site_use_id NUMBER) IS
345: SELECT
346: cas.cust_account_id
347: FROM
348: hz_cust_acct_sites cas,
349: hz_cust_site_uses su
350: WHERE
351: su.cust_acct_site_id = cas.cust_acct_site_id
352: and su.site_use_id = p_site_use_id;