569: X_PROMPT_TEXT,
570: X_TOOLTIP_TEXT,
571: L.LANGUAGE_CODE,
572: userenv('LANG')
573: from FND_LANGUAGES L
574: where L.INSTALLED_FLAG in ('I', 'B')
575: and not exists
576: (select NULL
577: from HR_ITEM_PROPERTIES_TL T
1215: B.PROMPT_TEXT,
1216: B.TOOLTIP_TEXT,
1217: L.LANGUAGE_CODE,
1218: B.SOURCE_LANG
1219: from HR_ITEM_PROPERTIES_TL B, FND_LANGUAGES L
1220: where L.INSTALLED_FLAG in ('I', 'B')
1221: and B.LANGUAGE = userenv('LANG')
1222: and not exists
1223: (select NULL