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_TASKS_PUB dependencies on AHL_VISITS_B

Line 191: SELECT organization_id FROM ahl_visits_b

187: l_index NUMBER;
188: l_temp_num NUMBER;
189:
190: CURSOR validate_visit_id_csr(c_visit_id IN NUMBER) IS
191: SELECT organization_id FROM ahl_visits_b
192: WHERE visit_id = c_visit_id
193: AND status_code in ('RELEASED', 'PLANNING', 'PARTIALLY RELEASED');
194:
195: CURSOR validate_visit_number_csr(c_visit_number IN NUMBER) IS

Line 196: SELECT visit_id, organization_id FROM ahl_visits_b

192: WHERE visit_id = c_visit_id
193: AND status_code in ('RELEASED', 'PLANNING', 'PARTIALLY RELEASED');
194:
195: CURSOR validate_visit_number_csr(c_visit_number IN NUMBER) IS
196: SELECT visit_id, organization_id FROM ahl_visits_b
197: WHERE visit_number = c_visit_number
198: AND status_code in ('RELEASED', 'PLANNING', 'PARTIALLY RELEASED');
199:
200: CURSOR validate_dept_id_csr(c_dept_id IN NUMBER, c_org_id IN NUMBER) IS