DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 563: FROM per_pos_structure_elements p

559: ppf.current_npw_flag, 'EC', (select 'Y' from dual where
560: ppf.current_employee_flag = 'Y' or ppf.current_npw_flag = 'Y') )) )
561: AND ( asg.position_id in
562: (select o.subordinate_position_id from (SELECT p.subordinate_position_id
563: FROM per_pos_structure_elements p
564: CONNECT BY p.parent_position_id = PRIOR p.subordinate_position_id
565: AND p.pos_structure_version_id = PRIOR p.pos_structure_version_id
566: AND LEVEL <= NVL(p_plan_rec.hierarchy_levels, LEVEL)
567: START WITH p.parent_position_id = p_plan_rec.top_position_id