APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_TASK_LINKS

Line 1272: ( SELECT PARENT_TASK_ID FROM AHL_TASK_LINKS WHERE VISIT_TASK_ID = P_VISIT_TASK_ID )) ,

1268: AHL_VISIT_TASKS_b t
1269: WHERE
1270: s.stage_id = t.stage_id and
1271: t.VISIT_task_id IN
1272: ( SELECT PARENT_TASK_ID FROM AHL_TASK_LINKS WHERE VISIT_TASK_ID = P_VISIT_TASK_ID )) ,
1273: ( SELECT
1274: nvl(min(stage_num),l_max_stage_num) min_child_stage_num
1275: FROM
1276: ahl_vwp_stages_b s,

Line 1281: ( SELECT visit_TASK_ID FROM AHL_TASK_LINKS WHERE parent_TASK_ID = P_VISIT_TASK_ID ));

1277: AHL_VISIT_TASKS_b t
1278: WHERE
1279: s.stage_id = t.stage_id and
1280: t.VISIT_task_id IN
1281: ( SELECT visit_TASK_ID FROM AHL_TASK_LINKS WHERE parent_TASK_ID = P_VISIT_TASK_ID ));
1282:
1283:
1284: CURSOR C_STAGE_NUM(P_VISIT_ID NUMBER, P_STAGE_NAME VARCHAR2)
1285: is