133: X_LAST_UPDATE_DATE,
134: X_LAST_UPDATED_BY,
135: L.LANGUAGE_CODE,
136: userenv('LANG')
137: from FND_LANGUAGES L
138: where L.INSTALLED_FLAG in ('I', 'B')
139: and not exists
140: (select NULL
141: from AHL_SUBSCRIPTIONS_TL T
464: B.LAST_UPDATE_DATE,
465: B.LAST_UPDATED_BY,
466: L.LANGUAGE_CODE,
467: B.SOURCE_LANG
468: from AHL_SUBSCRIPTIONS_TL B, FND_LANGUAGES L
469: where L.INSTALLED_FLAG in ('I', 'B')
470: and B.LANGUAGE = userenv('LANG')
471: and not exists
472: (select NULL