APPS.PER_GRADES_PKG dependencies on HR_POSITIONS

Line 635: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions) Date tracked position req.

631: WHERE vg.business_group_id + 0 = p_bgroup
632: AND vg.grade_id = p_grd_id
633: AND vg.date_from > p_date_to;
634: --
635: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions) Date tracked position req.
636: --
637: UPDATE per_valid_grades vg
638: SET vg.date_to = (select least(
639: nvl(p.date_end,p_eot),

Line 642: from hr_positions p,

638: SET vg.date_to = (select least(
639: nvl(p.date_end,p_eot),
640: nvl(j.date_to,p_eot),
641: nvl(p_date_to,p_eot))
642: from hr_positions p,
643: per_jobs_v j,
644: per_valid_grades v
645: where v.valid_grade_id = vg.valid_grade_id
646: and v.position_id = p.position_id(+)