5030: FROM per_grade_definitions gdf
5031: ,per_grades grd
5032: WHERE grd.grade_id = l_grade_id
5033: AND grd.grade_definition_id = gdf.grade_definition_id
5034: AND grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
5035:
5036: --Bug# 9761810 Modified the cursor to consider Position all segments
5037: cursor c_det_pos_name(l_pos_id number) IS
5038: select pos.name pos_name