APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_REGIONS

Line 575: log_message('MSC.MSC_REGIONS');

571: log_message('MSC.MSC_TP_SITE_ID_LID');
572: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TP_SITE_ID_LID TO ' || x_dem_schema;
573: execute immediate x_grant_sql;
574:
575: log_message('MSC.MSC_REGIONS');
576: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_REGIONS TO ' || x_dem_schema;
577: execute immediate x_grant_sql;
578:
579: log_message('MSD.MSD_DEM_TIME');

Line 576: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_REGIONS TO ' || x_dem_schema;

572: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_TP_SITE_ID_LID TO ' || x_dem_schema;
573: execute immediate x_grant_sql;
574:
575: log_message('MSC.MSC_REGIONS');
576: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_REGIONS TO ' || x_dem_schema;
577: execute immediate x_grant_sql;
578:
579: log_message('MSD.MSD_DEM_TIME');
580: x_grant_sql := 'GRANT SELECT ON ' || x_msd_schema || '.MSD_DEM_TIME TO ' || x_dem_schema;

Line 1277: FROM msc_regions

1273: x_sr_instance_id NUMBER := NULL;
1274: BEGIN
1275: SELECT sr_instance_id
1276: INTO x_sr_instance_id
1277: FROM msc_regions
1278: WHERE zone = p_zone
1279: AND rownum < 2;
1280:
1281: RETURN x_sr_instance_id;