101: X_LAST_UPDATE_DATE,
102: X_LAST_UPDATE_LOGIN,
103: L.LANGUAGE_CODE,
104: userenv('LANG')
105: from FND_LANGUAGES L
106: where L.INSTALLED_FLAG in ('I', 'B')
107: and not exists
108: (select NULL
109: from HR_ORG_INFORMATION_TYPES_TL T
295: B.LAST_UPDATE_DATE,
296: B.LAST_UPDATE_LOGIN,
297: L.LANGUAGE_CODE,
298: B.SOURCE_LANG
299: from HR_ORG_INFORMATION_TYPES_TL B, FND_LANGUAGES L
300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL