DBA Data[Home] [Help]

APPS.OZF_VO_DISC_STRUCT_NAME_PKG dependencies on FND_LANGUAGES

Line 75: from ozf_offr_disc_struct_name_tl b, fnd_languages l

71: b.discount_table_name,
72: b.description,
73: l.language_code,
74: b.source_lang
75: from ozf_offr_disc_struct_name_tl b, fnd_languages l
76: where l.installed_flag in ('I', 'B')
77: and b.language = userenv('lang')
78: and not exists
79: (select null

Line 160: FROM fnd_languages l

156: , DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
157: , USERENV('LANG')
158: , p_name
159: , p_description
160: FROM fnd_languages l
161: WHERE l.installed_flag IN ('I','B')
162: AND NOT EXISTS(SELECT NULL FROM ozf_offr_disc_struct_name_tl t
163: WHERE t.offr_disc_struct_name_id = DECODE( px_offr_disc_struct_name_id, FND_API.G_MISS_NUM, NULL, px_offr_disc_struct_name_id)
164: AND t.language = l.language_code);

Line 368: from ozf_offer_adjustments_tl b, fnd_languages l

364: b.offer_adjustment_name,
365: b.description,
366: l.language_code,
367: b.source_lang
368: from ozf_offer_adjustments_tl b, fnd_languages l
369: where l.installed_flag in ('I', 'B')
370: and b.language = userenv('lang')
371: and not exists
372: (select null