83: X_NAME,
84: X_DESCRIPTION,
85: L.LANGUAGE_CODE,
86: userenv('LANG')
87: from FND_LANGUAGES L
88: where L.INSTALLED_FLAG in ('I', 'B')
89: and not exists
90: (select NULL
91: from AMS_USER_STATUSES_TL T
348: B.NAME,
349: B.DESCRIPTION,
350: L.LANGUAGE_CODE,
351: B.SOURCE_LANG
352: from AMS_USER_STATUSES_TL B, FND_LANGUAGES L
353: where L.INSTALLED_FLAG in ('I', 'B')
354: and B.LANGUAGE = userenv('LANG')
355: and not exists
356: (select NULL