[Home] [Help]
862: ))
863: AND (asg.position_id IN (
864: SELECT o.subordinate_position_id
865: FROM (SELECT p.subordinate_position_id
866: FROM per_pos_structure_elements p
867: CONNECT BY p.parent_position_id = PRIOR p.subordinate_position_id
868: AND p.pos_structure_version_id = PRIOR p.pos_structure_version_id
869: AND LEVEL <= NVL (p_plan_rec.hierarchy_levels, LEVEL)
870: START WITH p.parent_position_id = p_plan_rec.top_position_id