[Home] [Help]
519:
520: CURSOR cur_grd1 IS
521: SELECT gdf.segment1 pay_plan,
522: gdf.segment2 grade_or_level
523: FROM per_grade_definitions gdf,
524: per_grades grd
525: WHERE grd.grade_id = l_imm_pos_valid_grade.valid_grade
526: AND grd.grade_definition_id = gdf.grade_definition_id
527: AND grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');