51: X_CREATION_DATE,
52: X_LAST_UPDATE_LOGIN,
53: L.LANGUAGE_CODE,
54: userenv('LANG')
55: from FND_LANGUAGES L
56: where L.INSTALLED_FLAG in ('I', 'B')
57: and not exists
58: (select NULL
59: from GME_TEXT_TABLE_TL T
245: B.CREATION_DATE,
246: B.LAST_UPDATE_LOGIN,
247: L.LANGUAGE_CODE,
248: B.SOURCE_LANG
249: from GME_TEXT_TABLE_TL B, FND_LANGUAGES L
250: where L.INSTALLED_FLAG in ('I', 'B')
251: and B.LANGUAGE = userenv('LANG')
252: and not exists
253: (select NULL