APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PAY_GRADE_RULES_F

Line 144: from pay_grade_rules_f pgr

140: for update of person_id;
141: --
142: cursor csr_assignment_rate_values is
143: select pgr.rowid
144: from pay_grade_rules_f pgr
145: where exists (select 'x'
146: from per_assignments_f paf
147: where pgr.grade_or_spinal_point_id = paf.assignment_id
148: and paf.business_group_id + 0 = p_business_group_id

Line 3444: FROM pay_grade_rules_f pgr

3440: AND p.effective_end_date = p_date_start -1;
3441: --
3442: CURSOR csr_assignment_rate_values IS
3443: SELECT pgr.rowid
3444: FROM pay_grade_rules_f pgr
3445: WHERE EXISTS (SELECT 'X'
3446: FROM per_assignments_f paf
3447: WHERE pgr.grade_or_spinal_point_id = paf.assignment_id
3448: and paf.business_group_id + 0 = p_business_group_id

Line 3598: DELETE from pay_grade_rules_f pgr

3594: FOR assignment_rate_rec in csr_assignment_rate_values LOOP
3595: --
3596: hr_utility.set_location(l_proc,120);
3597: --
3598: DELETE from pay_grade_rules_f pgr
3599: WHERE pgr.rowid = assignment_rate_rec.rowid;
3600: --
3601: END LOOP;
3602: --