288: p_name in varchar2 ) is
289: --
290: cursor csr_ins_langs is
291: select l.language_code 292: from fnd_languages l 293: where l.installed_flag in ('I','B')
294: and not exists (select null
295: from pqh_transaction_categories_tl ctl
296: where ctl.transaction_category_id = p_transaction_category_id