154: ltrim(rtrim(X_CODE)),
155: X_DESCRIPTION,
156: L.LANGUAGE_CODE,
157: userenv('LANG')
158: from FND_LANGUAGES L
159: where L.INSTALLED_FLAG in ('I', 'B')
160: and not exists
161: (select NULL
162: from AS_INTEREST_CODES_TL T
560: B.CODE,
561: B.DESCRIPTION,
562: L.LANGUAGE_CODE,
563: B.SOURCE_LANG
564: from AS_INTEREST_CODES_TL B, FND_LANGUAGES L
565: where L.INSTALLED_FLAG in ('I', 'B')
566: and B.LANGUAGE = userenv('LANG')
567: and not exists
568: (select NULL