APPS.AHL_VWP_TASKS_LINKS_PVT dependencies on AHL_STAGE_LINKS

Line 192: SELECT 'X' FROM ahl_stage_links

188:
189: --Check if the task rule being created voilates the already defined stage rules
190: CURSOR c_validate_rules (p_parent_stage_id IN NUMBER, p_child_stage_id IN NUMBER)
191: IS
192: SELECT 'X' FROM ahl_stage_links
193: WHERE subject_id = p_child_stage_id
194: AND relation_type <> 'PARALLEL'
195: START WITH object_id = p_parent_stage_id
196: CONNECT BY PRIOR subject_id = object_id;