342: -- Cursor to obtain the list of base and installed languages
343: --
344: cursor csr_ins_langs is
345: select l.language_code 346: from fnd_languages l 347: where l.installed_flag in ('I','B')
348: and not exists (select null
349: from hr_item_properties_tl ipt
350: where ipt.item_property_id = p_item_property_id