APPS.HR_ASSIGNMENT_INTERNAL dependencies on PAY_GRADE_RULES_F

Line 666: from pay_grade_rules_f pgr

662: and effective_end_date;
663: --
664: cursor csr_lock_asg_rates is
665: select pgr.grade_or_spinal_point_id
666: from pay_grade_rules_f pgr
667: where pgr.grade_or_spinal_point_id = p_assignment_id
668: and rate_type = 'A'
669: and p_final_process_Date between pgr.effective_start_date
670: and pgr.effective_end_date;

Line 841: update pay_grade_rules_f pgr

837: and abv.effective_start_date > p_final_process_date;
838: --
839: hr_utility.set_location(l_proc, 214);
840: --
841: update pay_grade_rules_f pgr
842: set pgr.effective_end_date = p_final_process_date
843: where pgr.grade_or_spinal_point_id = p_assignment_id
844: and pgr.rate_type = 'A'
845: and p_final_process_date between pgr.effective_start_date

Line 850: delete pay_grade_rules_f pgr

846: and pgr.effective_end_date;
847: --
848: hr_utility.set_location(l_proc,220);
849: --
850: delete pay_grade_rules_f pgr
851: where grade_or_spinal_point_Id = p_assignment_id
852: and pgr.rate_type = 'A'
853: and pgr.effective_start_Date > p_final_process_date;
854: --