APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PER_COMPETENCES_VL

Line 7258: l_competence_name per_competences_vl.name%type := null;

7254: p_competence_id in number
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

Line 7263: from per_competences_vl pco

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
7264: where pco.competence_id = p_competence_id;
7265:
7266: cursor c_rating_level_name is
7267: select rtl.name