474: select l.language_code
475: , l.nls_language
476: , cd.id_flex_num
477: , cd.competence_definition_id
478: from fnd_languages l
479: , per_competences cpn
480: , per_competence_definitions cd
481: where cpn.competence_id = p_competence_id
482: and cpn.competence_definition_id = cd.competence_definition_id