DBA Data[Home] [Help]

APPS.GHR_VALIDATE_CHECK dependencies on PER_GRADES

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

356:
357: --Start of 3604377
358: l_pos_ei_grade_data per_position_extra_info%rowtype;
359:
360: CURSOR cur_grd(p_grade_id per_grades.grade_id%TYPE) IS
361: SELECT gdf.segment1 pay_plan
362: ,gdf.segment2 grade_or_level
363: FROM per_grade_definitions gdf
364: ,per_grades grd

Line 364: ,per_grades grd

360: CURSOR cur_grd(p_grade_id per_grades.grade_id%TYPE) IS
361: SELECT gdf.segment1 pay_plan
362: ,gdf.segment2 grade_or_level
363: FROM per_grade_definitions gdf
364: ,per_grades grd
365: WHERE grd.grade_id = p_grade_id
366: AND grd.grade_definition_id = gdf.grade_definition_id;
367: --End of 3604377
368: