74: X_LAST_UPDATE_LOGIN,
75: X_LAST_UPDATE_DATE,
76: L.LANGUAGE_CODE,
77: userenv('LANG')
78: from FND_LANGUAGES L
79: where L.INSTALLED_FLAG in ('I', 'B')
80: and not exists
81: (select NULL
82: from BNE_CACHE_DIRECTIVES_TL T
289: B.LAST_UPDATE_LOGIN,
290: B.LAST_UPDATE_DATE,
291: L.LANGUAGE_CODE,
292: B.SOURCE_LANG
293: from BNE_CACHE_DIRECTIVES_TL B, FND_LANGUAGES L
294: where L.INSTALLED_FLAG in ('I', 'B')
295: and B.LANGUAGE = userenv('LANG')
296: and not exists
297: (select NULL