APPS.DPP_NOTIFICATION_PVT dependencies on DPP_LOOKUPS

Line 162: FROM dpp_lookups

158: IF l_notif_territory IS NULL THEN
159: BEGIN
160: SELECT tag
161: INTO l_notif_territory
162: FROM dpp_lookups
163: WHERE lookup_code = UPPER(p_notif_language)
164: AND lookup_type = 'DPP_LANG_DFLT_TERRITORY';
165: EXCEPTION
166: WHEN NO_DATA_FOUND THEN

Line 344: dpp_lookups dl

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';
348: EXCEPTION