DBA Data[Home] [Help]

APPS.AMS_CLIK_THRU_ACT_PKG dependencies on FND_LANGUAGES

Line 110: FROM fnd_languages l

106: ,DECODE(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,X_LAST_UPDATED_BY)
107: ,DECODE(X_CREATION_DATE,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,X_CREATION_DATE)
108: ,DECODE(X_CREATED_BY,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,X_CREATED_BY)
109: ,DECODE(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,X_LAST_UPDATE_LOGIN)
110: FROM fnd_languages l
111: WHERE l.installed_flag IN ('I', 'B')
112: AND NOT EXISTS
113: (SELECT NULL
114: FROM AMS_CLIK_THRU_ACTIONS_TL T

Line 565: FROM ams_clik_thru_actions_tl b, fnd_languages l

561: b.last_update_date,
562: b.last_update_login,
563: l.language_code,
564: b.source_lang
565: FROM ams_clik_thru_actions_tl b, fnd_languages l
566: WHERE l.installed_flag IN ('I', 'B')
567: AND b.LANGUAGE = USERENV('lang')
568: AND NOT EXISTS
569: (SELECT NULL