99: L.LANGUAGE_CODE,
100: --Added for performance issue due to literals - 27-Jul-2004
101: --userenv('LANG')
102: L_LANG
103: from FND_LANGUAGES L
104: --Added for performance issue due to literals - 27-Jul-2004
105: --where L.INSTALLED_FLAG in ('I', 'B')
106: where L.INSTALLED_FLAG in ( L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
107: and not exists
384: B.OUTCOME_CODE,
385: B.MEDIA_TYPE,
386: L.LANGUAGE_CODE,
387: B.SOURCE_LANG
388: from JTF_IH_OUTCOMES_TL B, FND_LANGUAGES L
389: where L.INSTALLED_FLAG in (L_INSTALLED_FLAG1, L_INSTALLED_FLAG2)
390: and B.LANGUAGE = L_LANG
391: and not exists
392: (select NULL