APPS.PAY_PGR_BUS dependencies on PER_GRADES

Line 248: l_grade_id per_grades.grade_id%TYPE;

244: --
245: l_proc VARCHAR2(72) := g_package || 'chk_grade_or_spinal_point_id';
246: --l_eligy_prfl_id per_cagr_entitlement_lines_f.oipl_id%TYPE;
247: l_assignment_id per_assignments_f.assignment_id%TYPE;
248: l_grade_id per_grades.grade_id%TYPE;
249: l_spinal_point_id per_spinal_points.spinal_point_id%TYPE;
250: l_dummy_id NUMBER(15);
251: --
252: --

Line 266: FROM per_grades g

262: AND paf.effective_end_date;
263: --
264: CURSOR csr_chk_grade_id IS
265: SELECT g.grade_id
266: FROM per_grades g
267: WHERE g.grade_id = l_grade_id
268: AND p_effective_date BETWEEN g.date_from
269: AND nvl(g.date_to, p_effective_date + 1)
270: AND g.business_group_id = p_business_group_id; -- Bug 3640364

Line 321: -- per_grades

317: END IF;
318: --
319: -- IF the rate type is for Grade Rates then
320: -- check that p_grade_or_spinal_point_id exists in
321: -- per_grades
322: --
323: ELSIF p_rate_type = 'G' THEN
324: --
325: hr_utility.set_location(l_proc,60);