121: X_CREATION_DATE,
122: X_ACTION_ID,
123: L.LANGUAGE_CODE,
124: userenv('LANG')
125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B')
127: and not exists
128: (select NULL
129: from ENG_CHANGE_ACTIONS_TL T
444: B.CREATION_DATE,
445: B.ACTION_ID,
446: L.LANGUAGE_CODE,
447: B.SOURCE_LANG
448: from ENG_CHANGE_ACTIONS_TL B, FND_LANGUAGES L
449: where L.INSTALLED_FLAG in ('I', 'B')
450: and B.LANGUAGE = userenv('LANG')
451: and not exists
452: (select /*+ parallel(T) */ NULL