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.AHL_VWP_VISITS_PUB dependencies on AHL_UNIT_CONFIG_HEADERS

Line 192: SELECT name FROM ahl_unit_config_headers

188: l_service_id NUMBER;
189: l_temp_code VARCHAR2(30);
190:
191: CURSOR get_unit_name_csr(c_uc_header_id IN NUMBER) IS
192: SELECT name FROM ahl_unit_config_headers
193: WHERE unit_config_header_id = c_uc_header_id;
194:
195: CURSOR get_unit_id_csr(c_uc_name IN VARCHAR2) IS
196: SELECT unit_config_header_id FROM ahl_unit_config_headers

Line 196: SELECT unit_config_header_id FROM ahl_unit_config_headers

192: SELECT name FROM ahl_unit_config_headers
193: WHERE unit_config_header_id = c_uc_header_id;
194:
195: CURSOR get_unit_id_csr(c_uc_name IN VARCHAR2) IS
196: SELECT unit_config_header_id FROM ahl_unit_config_headers
197: WHERE name = c_uc_name;
198:
199: CURSOR get_proj_template_name_csr(c_proj_template_id IN NUMBER) IS
200: SELECT name FROM pa_projects