DBA Data[Home] [Help]

APPS.DPP_NOTIFICATION_PVT dependencies on FND_LANGUAGES

Line 339: FROM fnd_languages

335: IF p_language_code IS NOT NULL THEN
336: BEGIN
337: SELECT nls_language
338: INTO l_language_code
339: FROM fnd_languages
340: WHERE upper((iso_language||'-'||iso_territory)) = UPPER(p_language_code);
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: BEGIN

Line 346: FROM fnd_languages fl,

342: WHEN NO_DATA_FOUND THEN
343: BEGIN
344: SELECT fl.nls_language
345: INTO l_language_code
346: FROM fnd_languages fl,
347: dpp_lookups dl
348: WHERE upper((fl.iso_language||'-'||fl.iso_territory)) = UPPER((p_language_code||'-'||dl.tag))
349: AND dl.lookup_code = UPPER(p_language_code)
350: AND dl.lookup_type = 'DPP_LANG_DFLT_TERRITORY';