378: -- Cursor to obtain the list of base and installed languages
379: --
380: cursor csr_ins_langs is
381: select l.language_code 382: from fnd_languages l 383: where l.installed_flag in ('I','B')
384: and not exists (select null
385: from ota_certifications_tl ctl
386: where ctl.certification_id = p_certification_id