APPS.HR_ASSIGNMENT_INTERNAL dependencies on PAY_GRADE_RULES_F

Line 612: from pay_grade_rules_f pgr

608: and effective_end_date;
609: --
610: cursor csr_lock_asg_rates is
611: select pgr.grade_or_spinal_point_id
612: from pay_grade_rules_f pgr
613: where pgr.grade_or_spinal_point_id = p_assignment_id
614: and rate_type = 'A'
615: and p_final_process_Date between pgr.effective_start_date
616: and pgr.effective_end_date;

Line 775: update pay_grade_rules_f pgr

771: and abv.effective_start_date > p_final_process_date;
772: --
773: hr_utility.set_location(l_proc, 214);
774: --
775: update pay_grade_rules_f pgr
776: set pgr.effective_end_date = p_final_process_date
777: where pgr.grade_or_spinal_point_id = p_assignment_id
778: and pgr.rate_type = 'A'
779: and p_final_process_date between pgr.effective_start_date

Line 784: delete pay_grade_rules_f pgr

780: and pgr.effective_end_date;
781: --
782: hr_utility.set_location(l_proc,220);
783: --
784: delete pay_grade_rules_f pgr
785: where grade_or_spinal_point_Id = p_assignment_id
786: and pgr.rate_type = 'A'
787: and pgr.effective_start_Date > p_final_process_date;
788: --