APPS.GHR_LACS_REMARKS dependencies on PER_ASSIGNMENTS_F

Line 23: l_assignment_id per_assignments_f.assignment_id%TYPE;

19: PROCEDURE Fetch_Data(
20: p_pa_request_id ghr_pa_requests.pa_request_id%TYPE)
21: IS
22: l_grade_id per_grades.grade_id%TYPE;
23: l_assignment_id per_assignments_f.assignment_id%TYPE;
24: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
25: l_multi_error_flag boolean;
26: cursor c_grade_kff (grd_id number) is
27: select gdf.segment1

Line 63: FROM per_assignments_f paf

59: ELSE
60: l_location := 'Apply_894_Rules:Fetch_Data:Fetching Assignments';
61: SELECT paf.assignment_id, paf.grade_id
62: INTO l_assignment_id, l_grade_id
63: FROM per_assignments_f paf
64: WHERE paf.person_id = g_requests_rec.person_id
65: AND paf.primary_flag = 'Y'
66: AND paf.assignment_type <> 'B'
67: AND g_requests_rec.effective_date BETWEEN