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_POPULATE_TIMEZONE_PKG dependencies on HZ_PHONE_AREA_CODES

Line 128: from hz_phone_area_codes

124: where phone_country_code = p_phone_country_code;
125:
126: cursor get_area_code_tzone_csr is
127: select timezone_id
128: from hz_phone_area_codes
129: where phone_country_code = p_phone_country_code
130: and area_code = p_area_code;
131:
132: cursor get_area_code_count_csr is

Line 134: from hz_phone_area_codes

130: and area_code = p_area_code;
131:
132: cursor get_area_code_count_csr is
133: select count(*)
134: from hz_phone_area_codes
135: where phone_country_code = p_phone_country_code
136: and area_code = p_area_code;
137:
138: cursor get_area_code_tz_csr is

Line 140: from hz_phone_area_codes

136: and area_code = p_area_code;
137:
138: cursor get_area_code_tz_csr is
139: select timezone_id
140: from hz_phone_area_codes
141: where phone_country_code = p_phone_country_code
142: and area_code = p_area_code
143: and territory_code = p_country_code;
144: