APPS.WIP_BIS_UTZ_ALERT dependencies on BIS_REGIONS_V

Line 360: FROM bis_regions_v

356: l_geo_level := 'REGION';
357: END IF;
358: IF(dimension1_level >= 4) THEN
359: SELECT MAX(region_code) INTO l_region_id
360: FROM bis_regions_v
361: WHERE area_code = l_area_id AND country_code = l_country_id
362: AND name = region;
363: END IF;
364: