APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PER_RATING_LEVELS_VL

Line 7260: l_rating_level_name per_rating_levels_vl.name%type := null;

7256: ,p_rating_level_id in number
7257: ) return varchar2 is
7258:
7259: l_competence_name per_competences_vl.name%type := null;
7260: l_rating_level_name per_rating_levels_vl.name%type := null;
7261:
7262: cursor c_competence_name is
7263: select pco.name
7264: from per_competences_vl pco

Line 7269: from per_rating_levels_vl rtl

7265: where pco.competence_id = p_competence_id;
7266:
7267: cursor c_rating_level_name is
7268: select rtl.name
7269: from per_rating_levels_vl rtl
7270: where rtl.rating_level_id = p_rating_level_id;
7271: begin
7272: open c_competence_name;
7273: fetch c_competence_name into l_competence_name;