DBA Data[Home] [Help]

APPS.HR_CONTINGENT_WORKER_API dependencies on PAY_GRADE_RULES_F

Line 3716: UPDATE pay_grade_rules_f pgr

3712: SET spp.effective_end_date = l_effective_end_date
3713: WHERE spp.assignment_id = c_asg_rec.assignment_id
3714: AND spp.effective_end_date = l_final_process_date;
3715: --
3716: UPDATE pay_grade_rules_f pgr
3717: SET pgr.effective_end_date = l_effective_end_date
3718: WHERE pgr.grade_or_spinal_point_Id = c_asg_rec.assignment_id
3719: AND pgr.rate_type = 'A'
3720: AND pgr.effective_end_date = l_final_process_date;