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