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_category_usages_tl ctt
343: where ctt.category_usage_id = p_category_usage_id