348: -- Cursor to obtain the list of base and installed languages
349: --
350: cursor csr_ins_langs is
351: select l.language_code 352: from fnd_languages l 353: where l.installed_flag in ('I','B')
354: and not exists (select null
355: from per_competences_tl cpl
356: where cpl.competence_id = p_competence_id