81: X_DIMENSION_ID,
82: X_DIMENSION_GROUP_ID,
83: L.LANGUAGE_CODE,
84: userenv('LANG')
85: from FND_LANGUAGES L
86: where L.INSTALLED_FLAG in ('I', 'B')
87: and not exists
88: (select NULL
89: from FEM_DIMENSION_GRPS_TL T
308: B.DIMENSION_ID,
309: B.DIMENSION_GROUP_ID,
310: L.LANGUAGE_CODE,
311: B.SOURCE_LANG
312: from FEM_DIMENSION_GRPS_TL B, FND_LANGUAGES L
313: where L.INSTALLED_FLAG in ('I', 'B')
314: and B.LANGUAGE = userenv('LANG')
315: and not exists
316: (select NULL