249: X_CAGR_ENTITLEMENT_ITEM_ID,
250: X_ITEM_NAME,
251: L.LANGUAGE_CODE,
252: userenv('LANG')
253: from FND_LANGUAGES L
254: where L.INSTALLED_FLAG in ('I', 'B')
255: and not exists
256: (select NULL
257: from PER_CAGR_ENTITLEMENT_ITEMS_TL T
721: B.CAGR_ENTITLEMENT_ITEM_ID,
722: B.ITEM_NAME,
723: L.LANGUAGE_CODE,
724: B.SOURCE_LANG
725: from PER_CAGR_ENTITLEMENT_ITEMS_TL B, FND_LANGUAGES L
726: where L.INSTALLED_FLAG in ('I', 'B')
727: and B.LANGUAGE = userenv('LANG')
728: and not exists
729: (select NULL