160: X_LAST_UPDATE_DATE,
161: X_LAST_UPDATED_BY,
162: L.LANGUAGE_CODE,
163: userenv('LANG')
164: from FND_LANGUAGES L
165: where L.INSTALLED_FLAG in ('I', 'B')
166: and not exists
167: (select NULL
168: from AHL_DOC_REVISIONS_TL T
543: B.LAST_UPDATE_DATE,
544: B.LAST_UPDATED_BY,
545: L.LANGUAGE_CODE,
546: B.SOURCE_LANG
547: from AHL_DOC_REVISIONS_TL B, FND_LANGUAGES L
548: where L.INSTALLED_FLAG in ('I', 'B')
549: and B.LANGUAGE = userenv('LANG')
550: and not exists
551: (select NULL