APPS.MSC_GET_NAME dependencies on MSC_PLAN_SCHEDULES

Line 1709: msc_plan_schedules sch

1705: -- Return null if it is a dp scenario and the plan_id is passed in function call
1706: cursor is_forecast_c is
1707: select 1
1708: from msc_designators desig,
1709: msc_plan_schedules sch
1710: where desig.designator_id = p_desig_id
1711: and desig.designator_type = 6
1712: and sch.plan_id=p_plan_id
1713: and sch.input_schedule_id = desig.forecast_set_id;

Line 1784: FROM msc_plan_schedules

1780:
1781:
1782: cursor c_designator_type_g is
1783: SELECT designator_type
1784: FROM msc_plan_schedules
1785: WHERE plan_id = p_plan_id
1786: AND organization_id = -1
1787: AND sr_instance_id = p_instance_id
1788: AND input_schedule_id = p_desig_id;

Line 1792: FROM msc_plan_schedules

1788: AND input_schedule_id = p_desig_id;
1789:
1790: CURSOR c_designator_type IS
1791: SELECT designator_type
1792: FROM msc_plan_schedules
1793: WHERE plan_id = p_plan_id
1794: AND organization_id = p_organization_id
1795: AND sr_instance_id = p_instance_id
1796: AND input_schedule_id = p_desig_id;

Line 1800: FROM msc_plan_schedules

1796: AND input_schedule_id = p_desig_id;
1797:
1798: CURSOR c_coll_designator_type IS
1799: SELECT designator_type
1800: FROM msc_plan_schedules
1801: WHERE organization_id = p_organization_id
1802: AND sr_instance_id = p_instance_id
1803: AND input_schedule_id = p_desig_id;
1804:

Line 1824: FROM msc_plan_schedules

1820: l_designator_type NUMBER;
1821:
1822: cursor l_count_c is
1823: SELECT count(*)
1824: FROM msc_plan_schedules
1825: WHERE plan_id = p_plan_id
1826: AND organization_id = p_organization_id
1827: AND sr_instance_id = p_instance_id
1828: AND input_schedule_id = p_desig_id;

Line 1883: FROM msc_plan_schedules

1879: -- cnazarma
1880:
1881: CURSOR c_designator_type IS
1882: SELECT designator_type
1883: FROM msc_plan_schedules
1884: WHERE plan_id = p_plan_id
1885: AND organization_id = p_organization_id
1886: AND sr_instance_id = p_instance_id
1887: AND input_schedule_id = p_desig_id;

Line 2321: -- to msc_plan_schedules

2317: p_schedule_desig_id number,
2318: p_fb_type number)
2319: return number IS
2320: -- Modified to check the existance of forecast by joining msc_designators
2321: -- to msc_plan_schedules
2322: -- Also modified to remove the sub queries
2323: cursor is_forecast_c is
2324: select 1
2325: from msc_designators desig,

Line 2326: msc_plan_schedules sch

2322: -- Also modified to remove the sub queries
2323: cursor is_forecast_c is
2324: select 1
2325: from msc_designators desig,
2326: msc_plan_schedules sch
2327: where desig.designator_id = p_schedule_desig_id
2328: and desig.designator_type = 6
2329: and sch.plan_id=p_plan_id
2330: and sch.input_schedule_id = desig.forecast_set_id;

Line 2340: from msc_plan_schedules

2336: and desig.designator_type = 6;
2337:
2338: CURSOR is_dp_scenario_c is
2339: SELECT 1
2340: from msc_plan_schedules
2341: where plan_id = p_plan_id
2342: and input_schedule_id=p_schedule_desig_id
2343: and designator_type=7;
2344:

Line 3143: msc_plan_schedules ps

3139:
3140: select count(*)
3141: into l_count
3142: from msd_dp_scn_output_levels_v dp,
3143: msc_plan_schedules ps
3144: where ps.input_schedule_id = dp.scenario_id
3145: and ps.designator_type = 7
3146: and dp.level_id in (11, 15, 41)
3147: and ps.plan_id = p_plan_id