APPS.DPP_NOTIFICATION_PVT dependencies on FND_LANGUAGES

Line 336: FROM fnd_languages

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

Line 343: FROM fnd_languages fl,

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