APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_PLANS

Line 535: log_message('MSC.MSC_PLANS');

531:
532: /* grant select on required tables */
533: log_message ('Granting SELECT privilege on following tables to ' || x_dem_schema || ' schema.');
534:
535: log_message('MSC.MSC_PLANS');
536: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_PLANS TO ' || x_dem_schema;
537: execute immediate x_grant_sql;
538:
539: log_message ('MSC.MSC_INT_PUBLISH_DATA');

Line 536: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_PLANS TO ' || x_dem_schema;

532: /* grant select on required tables */
533: log_message ('Granting SELECT privilege on following tables to ' || x_dem_schema || ' schema.');
534:
535: log_message('MSC.MSC_PLANS');
536: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_PLANS TO ' || x_dem_schema;
537: execute immediate x_grant_sql;
538:
539: log_message ('MSC.MSC_INT_PUBLISH_DATA');
540: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_INT_PUBLISH_DATA TO ' || x_dem_schema;

Line 1532: from msc_plans

1528: and period_start_date > p_period_start_date;
1529:
1530: cursor c2 (p_plan_id in number) IS
1531: select CURR_CUTOFF_DATE
1532: from msc_plans
1533: where plan_id = p_plan_id;
1534:
1535: CURSOR c3 (p_date IN DATE) IS
1536: SELECT end_date

Line 1801: msc_plans

1797: x_curr_start_date,
1798: x_planned_bucket,
1799: x_planned_bucket_type
1800: FROM
1801: msc_plans
1802: WHERE
1803: plan_id = p_plan_id;
1804:
1805: /* Get calendar for the plan owning org */