APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_POSITIONS

Line 568: AND p.pos_structure_version_id = p_plan_rec.pos_structure_version_id) o, per_positions pos

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
568: AND p.pos_structure_version_id = p_plan_rec.pos_structure_version_id) o, per_positions pos
569: where o.subordinate_position_id = pos.position_id
570: and p_effective_date between pos.date_effective and nvl(pos.date_end,p_effective_date)
571: UNION
572: select p_plan_rec.top_position_id subordinate_position_id from dual));