328: -- Cursor to obtain the list of base and installed languages
329: --
330: cursor csr_ins_langs is
331: select l.language_code 332: from fnd_languages l 333: where l.installed_flag in ('I','B')
334: and not exists (select null
335: from ota_events_tl ent
336: where ent.event_id = p_event_id