APPS.AHL_VWP_TASKS_LINKS_PVT dependencies on AHL_VWP_STAGES_B

Line 159: select stage_num from ahl_vwp_stages_b where stage_id = (SELECT stage_id

155:
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;

Line 168: select stage_num from ahl_vwp_stages_b where stage_id = (SELECT stage_id

164: */
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;