APPS.PAY_PGR_BUS dependencies on PER_SPINAL_POINTS

Line 249: l_spinal_point_id per_spinal_points.spinal_point_id%TYPE;

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: --
253: -- Delcare Cursors

Line 274: FROM per_spinal_points psp

270: AND g.business_group_id = p_business_group_id; -- Bug 3640364
271: --
272: CURSOR csr_chk_spinal_point_id IS
273: SELECT spinal_point_id psp
274: FROM per_spinal_points psp
275: WHERE psp.business_group_id = p_business_group_id
276: AND psp.spinal_point_id = l_spinal_point_id;
277: --
278: BEGIN

Line 340: -- per_spinal_points

336: END IF;
337: --
338: -- IF the rate type is for Scale Rates then
339: -- check that p_grade_or_spinal_point_id exists in
340: -- per_spinal_points
341: --
342: ELSIF p_rate_type = 'SP' THEN
343: --
344: hr_utility.set_location(l_proc,80);