APPS.IBC_CITEM_VERSIONS_PKG dependencies on FND_LANGUAGES

Line 185: FROM FND_LANGUAGES L

181: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
182: ,L.LANGUAGE_CODE
183: ,USERENV('LANG')
184: ,DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,p_citem_translation_status)
185: FROM FND_LANGUAGES L
186: WHERE L.INSTALLED_FLAG IN ('I', 'B')
187: AND NOT EXISTS
188: (SELECT NULL
189: FROM IBC_CITEM_VERSIONS_TL T

Line 389: FROM FND_LANGUAGES L

385: NULL, Fnd_Global.login_id, p_last_update_login),
386: L.LANGUAGE_CODE,
387: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
388: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)
389: FROM FND_LANGUAGES L
390: WHERE L.INSTALLED_FLAG IN ('I', 'B')
391: AND NOT EXISTS
392: (SELECT NULL
393: FROM IBC_CITEM_VERSIONS_TL T

Line 971: FROM IBC_CITEM_VERSIONS_TL B, FND_LANGUAGES L

967: B.SECURITY_GROUP_ID,
968: L.LANGUAGE_CODE,
969: B.SOURCE_LANG,
970: B.citem_translation_status
971: FROM IBC_CITEM_VERSIONS_TL B, FND_LANGUAGES L
972: WHERE L.INSTALLED_FLAG IN ('I', 'B')
973: AND B.LANGUAGE = USERENV('LANG')
974: AND NOT EXISTS
975: (SELECT NULL