394: -- Cursor to obtain the list of base and installed languages
395: --
396: cursor csr_ins_langs is
397: select l.language_code 398: from fnd_languages l 399: where l.installed_flag in ('I','B')
400: and not exists (select null
401: from irc_posting_contents_tl ipt
402: where ipt.posting_content_id = p_posting_content_id