473: IF p_proficiency_level_id is not null THEN
474: BEGIN
475: SELECT step_value
476: INTO l_rating_level_value
477: FROM per_rating_levels
478: WHERE rating_level_id = p_proficiency_level_id;
479: EXCEPTION
480: WHEN OTHERS THEN
481: l_rating_level_value := null;
573: IF l_old_rating_level_id is not null THEN
574: BEGIN
575: SELECT step_value
576: INTO l_old_rating_level_value
577: FROM per_rating_levels
578: WHERE rating_level_id = l_old_rating_level_id;
579: EXCEPTION
580: WHEN OTHERS THEN
581: l_old_rating_level_value := null;
585: IF p_rating_level_id is not null THEN
586: BEGIN
587: SELECT step_value
588: INTO l_rating_level_value
589: FROM per_rating_levels
590: WHERE rating_level_id = p_rating_level_id;
591: EXCEPTION
592: WHEN OTHERS THEN
593: l_rating_level_value := null;