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

Line 160: FROM ahl_visit_tasks_vl

156: -- Commented as per review comments
157: /*CURSOR c_child_task(p_child_task_id IN NUMBER)
158: IS
159: select stage_num from ahl_vwp_stages_b where stage_id = (SELECT stage_id
160: FROM ahl_visit_tasks_vl
161: WHERE visit_task_id = p_child_task_id);
162:
163: l_child_stage_num number;
164: */

Line 474: FROM AHL_VISIT_TASKS_VL

470: as
471: CURSOR get_task_info(c_visit_task_id Number,C_PARENT_TASK_NUMBER VARCHAR2)
472: IS
473: SELECT *
474: FROM AHL_VISIT_TASKS_VL
475: WHERE VISIT_TASK_NUMBER=C_PARENT_TASK_NUMBER
476: AND SUMMARY_TASK_FLAG='N'
477: AND VISIT_ID = (select visit_id
478: from AHL_VISIT_TASKS_B