APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PAY_GRADE_RULES_F

Line 312: from pay_grade_rules_f pgr

308: for update of person_id;
309: --
310: cursor csr_assignment_rate_values is
311: select pgr.rowid
312: from pay_grade_rules_f pgr
313: where exists (select 'x'
314: from per_assignments_f paf
315: where pgr.grade_or_spinal_point_id = paf.assignment_id
316: and paf.business_group_id + 0 = p_business_group_id

Line 4671: FROM pay_grade_rules_f pgr

4667: AND p.effective_end_date = p_date_start -1;
4668: --
4669: CURSOR csr_assignment_rate_values IS
4670: SELECT pgr.rowid
4671: FROM pay_grade_rules_f pgr
4672: WHERE EXISTS (SELECT 'X'
4673: FROM per_assignments_f paf
4674: WHERE pgr.grade_or_spinal_point_id = paf.assignment_id
4675: and paf.business_group_id + 0 = p_business_group_id

Line 4872: DELETE from pay_grade_rules_f pgr

4868: FOR assignment_rate_rec in csr_assignment_rate_values LOOP
4869: --
4870: hr_utility.set_location(l_proc,120);
4871: --
4872: DELETE from pay_grade_rules_f pgr
4873: WHERE pgr.rowid = assignment_rate_rec.rowid;
4874: --
4875: END LOOP;
4876: --