APPS.WIP_BIS_UTZ_ALERT dependencies on BIS_AREAS_V

Line 346: FROM bis_areas_v

342: l_geo_level := 'AREA';
343: END IF;
344: IF(dimension1_level >= 2) THEN
345: SELECT MAX(id) INTO l_area_id
346: FROM bis_areas_v
347: WHERE name = area;
348: END IF;
349: IF(dimension1_level = 3) /* COUNTRY */ THEN
350: l_geo_level := 'COUNTRY';