DBA Data[Home] [Help]

APPS.GHR_LACS_REMARKS dependencies on PER_GRADES

Line 22: l_grade_id per_grades.grade_id%TYPE;

18:
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

Line 29: from per_grades grd,

25: l_multi_error_flag boolean;
26: cursor c_grade_kff (grd_id number) is
27: select gdf.segment1
28: ,gdf.segment2
29: from per_grades grd,
30: per_grade_definitions gdf
31: where grd.grade_id = grd_id
32: and grd.grade_definition_id = gdf.grade_definition_id;
33: BEGIN