75: X_MEDIA_TYPE,
76: X_REASON_CODE,
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 JTF_IH_REASONS_TL T
314: B.MEDIA_TYPE,
315: B.REASON_CODE,
316: L.LANGUAGE_CODE,
317: B.SOURCE_LANG
318: from JTF_IH_REASONS_TL B, FND_LANGUAGES L
319: where L.INSTALLED_FLAG in ('I', 'B')
320: and B.LANGUAGE = userenv('LANG')
321: and not exists
322: (select NULL