APPS.IBC_CONTENT_TYPES_PKG dependencies on FND_LANGUAGES

Line 89: FROM FND_LANGUAGES L

85: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
86: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
87: ,L.LANGUAGE_CODE
88: ,USERENV('LANG')
89: FROM FND_LANGUAGES L
90: WHERE L.INSTALLED_FLAG IN ('I', 'B')
91: AND NOT EXISTS
92: (SELECT NULL
93: FROM IBC_CONTENT_TYPES_TL T

Line 301: FROM IBC_CONTENT_TYPES_TL B, FND_LANGUAGES L

297: B.LAST_UPDATE_DATE,
298: B.LAST_UPDATE_LOGIN,
299: L.LANGUAGE_CODE,
300: B.SOURCE_LANG
301: FROM IBC_CONTENT_TYPES_TL B, FND_LANGUAGES L
302: WHERE L.INSTALLED_FLAG IN ('I', 'B')
303: AND B.LANGUAGE = USERENV('LANG')
304: AND NOT EXISTS
305: (SELECT NULL

Line 550: FROM FND_LANGUAGES L

546: X_LAST_UPDATE_LOGIN,
547: X_SECURITY_GROUP_ID,
548: L.LANGUAGE_CODE,
549: USERENV('LANG')
550: FROM FND_LANGUAGES L
551: WHERE L.INSTALLED_FLAG IN ('I', 'B')
552: AND NOT EXISTS
553: (SELECT NULL
554: FROM IBC_CONTENT_TYPES_TL T