405: l_creation_date,
406: l_last_updated_by,
407: l_last_update_date,
408: l_last_update_login
409: from fnd_languages l
410: where l.installed_flag in ('I','B')
411: and not exists (select null
412: from pqh_rule_sets_tl rtl
413: where rtl.rule_set_id = l_rule_set_id
484: l_creation_date,
485: l_last_updated_by,
486: l_last_update_date,
487: l_last_update_login
488: from fnd_languages l
489: where l.installed_flag in ('I','B')
490: and not exists (select null
491: from pqh_rule_sets_tl rtl
492: where rtl.rule_set_id = l_rule_set_id
594: B.LAST_UPDATE_LOGIN,
595: B.LAST_UPDATED_BY,
596: L.LANGUAGE_CODE,
597: B.SOURCE_LANG
598: from PQH_RULE_SETS_TL B, FND_LANGUAGES L
599: where L.INSTALLED_FLAG in ('I', 'B')
600: and B.LANGUAGE = userenv('LANG')
601: and not exists
602: (select NULL