DBA Data[Home] [Help]

APPS.GHR_VALIDATE_CHECK dependencies on PER_GRADES

Line 416: CURSOR cur_grd(p_grade_id per_grades.grade_id%TYPE) IS

412:
413: --Start of 3604377
414: l_pos_ei_grade_data per_position_extra_info%rowtype;
415:
416: CURSOR cur_grd(p_grade_id per_grades.grade_id%TYPE) IS
417: SELECT gdf.segment1 pay_plan
418: ,gdf.segment2 grade_or_level
419: FROM per_grade_definitions gdf
420: ,per_grades grd

Line 420: ,per_grades grd

416: CURSOR cur_grd(p_grade_id per_grades.grade_id%TYPE) IS
417: SELECT gdf.segment1 pay_plan
418: ,gdf.segment2 grade_or_level
419: FROM per_grade_definitions gdf
420: ,per_grades grd
421: WHERE grd.grade_id = p_grade_id
422: AND grd.grade_definition_id = gdf.grade_definition_id;
423: --End of 3604377
424: