96: X_LAST_UPDATE_LOGIN,
97: -- X_SECURITY_GROUP_ID,
98: L.LANGUAGE_CODE,
99: userenv('LANG')
100: from FND_LANGUAGES L
101: where L.INSTALLED_FLAG in ('I', 'B')
102: and not exists
103: (select NULL
104: from JTF_PREFAB_POLICIES_TL T
339: B.LAST_UPDATE_LOGIN,
340: -- B.SECURITY_GROUP_ID,
341: L.LANGUAGE_CODE,
342: B.SOURCE_LANG
343: from JTF_PREFAB_POLICIES_TL B, FND_LANGUAGES L
344: where L.INSTALLED_FLAG in ('I', 'B')
345: and B.LANGUAGE = userenv('LANG')
346: and not exists
347: (select NULL