75: X_LAST_UPDATED_BY,
76: X_LAST_UPDATE_LOGIN,
77: L.LANGUAGE_CODE,
78: userenv('LANG')
79: FROM FND_LANGUAGES L
80: WHERE L.INSTALLED_FLAG IN ('I', 'B')
81: AND NOT EXISTS
82: (SELECT NULL
83: FROM ICX_CAT_CONTENT_ZONES_TL T
362: B.IMAGE,
363: L.LANGUAGE_CODE,
364: B.SOURCE_LANG
365: FROM ICX_CAT_CONTENT_ZONES_TL B,
366: FND_LANGUAGES L
367: WHERE L.INSTALLED_FLAG IN ('I', 'B')
368: AND B.LANGUAGE = userenv('LANG')
369: AND NOT EXISTS
370: (SELECT NULL