326: -- Cursor to obtain the list of base and installed languages
327: --
328: cursor csr_ins_langs is
329: select l.language_code 330: from fnd_languages l 331: where l.installed_flag in ('I','B')
332: and not exists (select null
333: from per_competence_outcomes_tl cot
334: where cot.outcome_id = p_outcome_id