115: X_RULE_ID,
116: X_DESCRIPTION,
117: L.LANGUAGE_CODE,
118: userenv('LANG')
119: from FND_LANGUAGES L
120: where L.INSTALLED_FLAG in ('I', 'B')
121: and not exists
122: (select NULL
123: from AHL_MC_RULES_TL T
411: B.RULE_ID,
412: B.DESCRIPTION,
413: L.LANGUAGE_CODE,
414: B.SOURCE_LANG
415: from AHL_MC_RULES_TL B, FND_LANGUAGES L
416: where L.INSTALLED_FLAG in ('I', 'B')
417: and B.LANGUAGE = userenv('LANG')
418: and not exists
419: (select NULL