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_STAGES_PVT dependencies on AHL_VISIT_TASKS_VL

Line 1397: from AHL_VISIT_TASKS_VL

1393:
1394: CURSOR c_stage_tasks_count (c_visit_id IN NUMBER, c_stage_id IN NUMBER)
1395: IS
1396: select count(1) as TASK_COUNT
1397: from AHL_VISIT_TASKS_VL
1398: where VISIT_ID = c_visit_id
1399: AND TASK_TYPE_CODE <> 'STAGE'
1400: AND STAGE_ID = c_stage_id;
1401:

Line 1407: from AHL_VISIT_TASKS_VL

1403:
1404: CURSOR c_stage_task_dets (c_visit_id IN NUMBER, c_stage_id IN NUMBER)
1405: IS
1406: select *
1407: from AHL_VISIT_TASKS_VL
1408: where VISIT_ID = c_visit_id
1409: AND TASK_TYPE_CODE = 'STAGE'
1410: AND STAGE_ID = c_stage_id;
1411: