DBA Data[Home] [Help]

APPS.HR_CONTINGENT_WORKER_API dependencies on PAY_GRADE_RULES_F

Line 4173: UPDATE pay_grade_rules_f pgr

4169: SET spp.effective_end_date = l_effective_end_date
4170: WHERE spp.assignment_id = c_asg_rec.assignment_id
4171: AND spp.effective_end_date = l_final_process_date;
4172: --
4173: UPDATE pay_grade_rules_f pgr
4174: SET pgr.effective_end_date = l_effective_end_date
4175: WHERE pgr.grade_or_spinal_point_Id = c_asg_rec.assignment_id
4176: AND pgr.rate_type = 'A'
4177: AND pgr.effective_end_date = l_final_process_date;