197: --
198: from per_competences cpn
199: , per_competence_definitions cd
200: , per_competences_tl cpl 201: , fnd_languages l 202: where cpn.competence_definition_id = cd.competence_definition_id
203: and cpn.competence_id = cpl.competence_id
204: and cpl.language = userenv('LANG')
205: and l.installed_flag in ('I', 'B')