DBA Data[Home] [Help]

APPS.AMS_COMPETITOR_PRODUCTS_B_PKG dependencies on FND_LANGUAGES

Line 191: FROM fnd_languages l

187: FND_GLOBAL.user_id,
188: DECODE( p_competitor_product_name, FND_API.g_miss_char, NULL, p_competitor_product_name),
189: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)
190: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
191: FROM fnd_languages l
192: WHERE l.installed_flag IN ('I','B')
193: AND NOT EXISTS(
194: SELECT NULL
195: FROM ams_competitor_products_tl t

Line 532: from AMS_COMPETITOR_PRODUCTS_TL B, FND_LANGUAGES L

528: B.CREATION_DATE,
529: B.CREATED_BY,
530: B.competitor_product_name,
531: B.DESCRIPTION
532: from AMS_COMPETITOR_PRODUCTS_TL B, FND_LANGUAGES L
533: where L.INSTALLED_FLAG in ('I', 'B')
534: and B.LANGUAGE = userenv('LANG')
535: and not exists
536: (select NULL