DBA Data[Home] [Help]

APPS.HR_MASS_MOVE_API dependencies on PER_VALID_GRADES

Line 1049: from per_valid_grades vgr

1045: where mmvgr.mass_move_id = p_mass_move_id
1046: and mmvgr.position_id = p_position_id
1047: and not exists
1048: (select vgr.grade_id
1049: from per_valid_grades vgr
1050: where vgr.position_id = l_new_position_id
1051: and vgr.grade_id = mmvgr.target_grade_id
1052: and vgr.business_group_id = l_business_group_id);
1053: --

Line 1694: -- valid grades will be inserted into per valid grades.

1690: );
1691: end loop;
1692: --
1693: -- For each valid grade that is in mm valid grades but not in per
1694: -- valid grades will be inserted into per valid grades.
1695: --
1696: for csr_vgr_rec in csr_vgr loop
1697: --
1698: hr_utility.set_location(l_proc, 100);