111: */
112: select MAX(step_value)
113: from
114: per_rating_levels prl
115: ,per_competences pce
116: where (prl.rating_scale_id = pce.rating_scale_id
117: OR pce.competence_id = prl.competence_id)
118: AND pce.competence_id = p_comp_id;
119:
125: */
126: select MIN(step_value)
127: from
128: per_rating_levels prl
129: ,per_competences pce
130: where (prl.rating_scale_id = pce.rating_scale_id
131: OR pce.competence_id = prl.competence_id)
132: AND pce.competence_id = p_comp_id;
133: