DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 866: FROM per_pos_structure_elements p

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