DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJUSTMENT_PKG dependencies on FND_LANGUAGES

Line 166: FROM fnd_languages l

162: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
163: USERENV('LANG'),
164: p_offer_adjustment_name,
165: p_description
166: FROM fnd_languages l
167: WHERE l.installed_flag IN ('I','B')
168: AND NOT EXISTS(SELECT NULL FROM ozf_offer_adjustments_tl t
169: WHERE t.offer_adjustment_id = DECODE( px_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, px_offer_adjustment_id)
170: AND t.language = l.language_code);

Line 418: from ozf_offer_adjustments_tl b, fnd_languages l

414: b.offer_adjustment_name,
415: b.description,
416: l.language_code,
417: b.source_lang
418: from ozf_offer_adjustments_tl b, fnd_languages l
419: where l.installed_flag in ('I', 'B')
420: and b.language = userenv('lang')
421: and not exists
422: (select null