APPS.MSD_DEM_UPLOAD_FORECAST dependencies on MSC_REGIONS

Line 637: FROM msc_regions mr

633: IF (x_zone IS NOT NULL)
634: THEN
635: SELECT mr.region_id
636: INTO x_sr_zone_pk
637: FROM msc_regions mr
638: WHERE
639: mr.zone = x_zone
640: AND mr.sr_instance_id = p_sr_instance_id;
641: END IF;

Line 942: x_from_clause := x_from_clause || ' msc_regions mr, ';

938: x_zone_level := get_level_column (x_profile_id, C_ZONE);
939: IF (x_zone_level IS NOT NULL)
940: THEN
941: x_sr_zone_id := ' mr.region_id ';
942: x_from_clause := x_from_clause || ' msc_regions mr, ';
943: ELSIF (x_cust_zone_level IS NOT NULL)
944: THEN
945: x_sr_zone_id := ' msd_dem_upload_forecast.get_zone_from_tpzone ( exp.' || x_cust_zone_level || ', mai.instance_id ) ';
946: END IF;