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 169: FROM ahl_visit_tasks_vl

165:
166: CURSOR c_parent_or_child_task(p_parent_or_child_task_id IN NUMBER)
167: IS
168: select stage_num from ahl_vwp_stages_b where stage_id = (SELECT stage_id
169: FROM ahl_visit_tasks_vl
170: WHERE visit_task_id = p_parent_or_child_task_id);
171:
172: l_parent_stage_num number;
173: l_child_stage_num number;

Line 447: FROM AHL_VISIT_TASKS_VL

443: as
444: CURSOR get_task_info(c_visit_task_id Number,C_PARENT_TASK_NUMBER VARCHAR2)
445: IS
446: SELECT *
447: FROM AHL_VISIT_TASKS_VL
448: WHERE VISIT_TASK_NUMBER=C_PARENT_TASK_NUMBER
449: AND SUMMARY_TASK_FLAG='N'
450: AND VISIT_ID = (select visit_id
451: from AHL_VISIT_TASKS_B