106: X_SIMULATION_PLAN_NAME,
107: X_DESCRIPTION,
108: L.LANGUAGE_CODE,
109: userenv('LANG')
110: from FND_LANGUAGES L
111: where L.INSTALLED_FLAG in ('I', 'B')
112: and not exists
113: (select NULL
114: from AHL_SIMULATION_PLANS_TL T
390: B.SIMULATION_PLAN_NAME,
391: B.DESCRIPTION,
392: L.LANGUAGE_CODE,
393: B.SOURCE_LANG
394: from AHL_SIMULATION_PLANS_TL B, FND_LANGUAGES L
395: where L.INSTALLED_FLAG in ('I', 'B')
396: and B.LANGUAGE = userenv('LANG')
397: and not exists
398: (select NULL