57: X_ACTION_ITEM,
58: X_SHORT_DESCRIPTION,
59: L.LANGUAGE_CODE,
60: userenv('LANG')
61: from FND_LANGUAGES L
62: where L.INSTALLED_FLAG in ('I', 'B')
63: and not exists
64: (select NULL
65: from JTF_IH_ACTION_ITEMS_TL T
240: B.ACTION_ITEM,
241: B.SHORT_DESCRIPTION,
242: L.LANGUAGE_CODE,
243: B.SOURCE_LANG
244: from JTF_IH_ACTION_ITEMS_TL B, FND_LANGUAGES L
245: where L.INSTALLED_FLAG in ('I', 'B')
246: and B.LANGUAGE = userenv('LANG')
247: and not exists
248: (select NULL