DBA Data[Home] [Help]

APPS.AMS_TCOP_PERIODS_PKG dependencies on FND_LANGUAGES

Line 77: FROM fnd_languages l

73: ,DECODE(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,X_LAST_UPDATED_BY)
74: ,DECODE(X_CREATION_DATE,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,X_CREATION_DATE)
75: ,DECODE(X_CREATED_BY,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,X_CREATED_BY)
76: ,DECODE(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,X_LAST_UPDATE_LOGIN)
77: FROM fnd_languages l
78: WHERE l.installed_flag IN ('I', 'B')
79: AND NOT EXISTS
80: (SELECT NULL
81: FROM AMS_TCOP_FR_PERIODS_TL T

Line 429: FROM AMS_TCOP_FR_PERIODS_TL b, fnd_languages l

425: b.LAST_UPDATE_DATE,
426: b.LAST_UPDATE_LOGIN,
427: l.language_code,
428: b.SOURCE_LANG
429: FROM AMS_TCOP_FR_PERIODS_TL b, fnd_languages l
430: WHERE l.installed_flag IN ('I', 'B')
431: AND b.LANGUAGE = USERENV('lang')
432: AND NOT EXISTS
433: (SELECT NULL