eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_TIMEZONE_PUB dependencies on HZ_PHONE_AREA_CODES

Line 329: from hz_phone_area_codes

325: where phone_country_code = p_phone_country_code;
326:
327: cursor get_area_code_tzone_csr is
328: select timezone_id
329: from hz_phone_area_codes
330: where phone_country_code = p_phone_country_code
331: and area_code = p_area_code;
332:
333: cursor get_area_code_count_csr is

Line 335: from hz_phone_area_codes

331: and area_code = p_area_code;
332:
333: cursor get_area_code_count_csr is
334: select count(*)
335: from hz_phone_area_codes
336: where phone_country_code = p_phone_country_code
337: and area_code = p_area_code;
338:
339: cursor get_area_code_tz_csr is

Line 341: from hz_phone_area_codes

337: and area_code = p_area_code;
338:
339: cursor get_area_code_tz_csr is
340: select timezone_id
341: from hz_phone_area_codes
342: where phone_country_code = p_phone_country_code
343: and area_code = p_area_code
344: and territory_code = p_country_code;
345: