107: FND_GLOBAL.user_id,
108: FND_GLOBAL.conc_login_id,
109: USERENV('LANG'),
110: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
111: FROM fnd_languages l
112: WHERE l.installed_flag in ('I', 'B')
113: AND NOT EXISTS(
114: SELECT NULL
115: FROM ams_dm_target_values_tl t
311: B.LAST_UPDATE_LOGIN,
312: B.DESCRIPTION,
313: L.LANGUAGE_CODE,
314: B.SOURCE_LANG
315: from AMS_DM_TARGET_VALUES_TL B, FND_LANGUAGES L
316: where L.INSTALLED_FLAG in ('I', 'B')
317: and B.LANGUAGE = userenv('LANG')
318: and not exists
319: (select NULL