DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_POSITIONS

Line 872: per_positions pos

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
871: AND p.pos_structure_version_id = p_plan_rec.pos_structure_version_id) o,
872: per_positions pos
873: WHERE o.subordinate_position_id = pos.position_id
874: AND p_effective_date BETWEEN pos.date_effective AND NVL (pos.date_end, p_effective_date)
875: UNION
876: SELECT p_plan_rec.top_position_id subordinate_position_id