211: X_LAST_UPDATE_LOGIN,
212: X_REMARKS,
213: L.LANGUAGE_CODE,
214: userenv('LANG')
215: from FND_LANGUAGES L
216: where L.INSTALLED_FLAG in ('I', 'B')
217: and not exists
218: (select NULL
219: from AHL_UNIT_EFFECTIVITIES_TL T
701: B.LAST_UPDATE_LOGIN,
702: B.REMARKS,
703: L.LANGUAGE_CODE,
704: B.SOURCE_LANG
705: from AHL_UNIT_EFFECTIVITIES_TL B, FND_LANGUAGES L
706: where L.INSTALLED_FLAG in ('I', 'B')
707: and B.LANGUAGE = userenv('LANG')
708: and not exists
709: (select NULL