340: -- Cursor to obtain the list of base and installed languages
341: --
342: cursor csr_ins_langs is
343: select l.language_code 344: from fnd_languages l 345: where l.installed_flag in ('I','B')
346: and not exists (select null
347: from pqp_exception_reports_tl ert
348: where ert.exception_report_id = p_exception_report_id