335: -- Cursor to obtain the list of base and installed languages
336: --
337: cursor csr_ins_langs is
338: select l.language_code 339: from fnd_languages l 340: where l.installed_flag in ('I','B')
341: and not exists (select null
342: from ota_announcements_tl ant
343: where ant.announcement_id = p_announcement_id