162: FND_GLOBAL.user_id,
163: FND_GLOBAL.login_id,
164: L.LANGUAGE_CODE,
165: userenv('LANG')
166: from FND_LANGUAGES L
167: where L.INSTALLED_FLAG in ('I', 'B')
168: and not exists
169: (select NULL
170: from WSH_CC_PARAMETER_SETUPS_TL T
791: B.CREATED_BY,
792: B.LAST_UPDATE_LOGIN,
793: L.LANGUAGE_CODE,
794: B.SOURCE_LANG
795: from WSH_CC_PARAMETER_SETUPS_TL B, FND_LANGUAGES L
796: where L.INSTALLED_FLAG in ('I', 'B')
797: and B.LANGUAGE = userenv('LANG')
798: and not exists
799: (select NULL
919: l_user_id,
920: 0,
921: L.LANGUAGE_CODE,
922: userenv('LANG')
923: from FND_LANGUAGES L
924: where L.INSTALLED_FLAG in ('I', 'B')
925: and not exists
926: (select NULL
927: from WSH_CC_PARAMETER_SETUPS_TL T