APPS.PAY_PGR_BUS dependencies on PER_ASSIGNMENTS_F

Line 247: l_assignment_id per_assignments_f.assignment_id%TYPE;

243: -- Delcare Local Variables
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: --

Line 257: FROM per_assignments_f PAF

253: -- Delcare Cursors
254: --
255: CURSOR csr_chk_assignment_id IS
256: SELECT paf.assignment_id
257: FROM per_assignments_f PAF
258: WHERE paf.business_group_id = p_business_group_id
259: AND paf.assignment_id = l_assignment_id
260: AND paf.assignment_type = 'C'
261: AND p_effective_date BETWEEN paf.effective_start_date

Line 302: -- per_assignments_f and that the assignment is

298: hr_utility.set_location(l_proc, 30);
299: --
300: -- IF the rate type is for Assignment Rates then
301: -- check that p_grade_or_spinal_point_id exists in
302: -- per_assignments_f and that the assignment is
303: -- a CWK assignment.
304: --
305: IF p_rate_type = 'A' THEN
306: hr_utility.set_location(l_proc,40);