APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PER_RATING_LEVELS_VL

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

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

Line 7268: from per_rating_levels_vl rtl

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