488: -- Define a cursor to get a competence which is referenced by a rating_scale.
489: --
490: cursor csr_get_competence_rating is
491: select null 492: from per_competences 493: where rating_scale_id = p_rating_scale_id;
494: --
495: -- Define a cursor to to check id rating scales has any levels that
496: -- are referenced in competence element