APPS.MSD_ASCP_FLOW dependencies on MSC_PLAN_SCHEDULES

Line 43: FROM msc_plan_schedules

39: WHERE plan_id = l_plan_id;
40:
41: CURSOR c_sch_count (l_plan_id IN NUMBER,l_instance_id IN NUMBER, l_org_id IN NUMBER, l_default_scenario_iD IN NUMBER) IS
42: SELECT count(*)
43: FROM msc_plan_schedules
44: WHERE plan_id = l_plan_id
45: AND organization_id = l_org_id
46: AND sr_instance_id = l_instance_id
47: AND input_schedule_id = l_default_scenario_id

Line 52: FROM msc_plan_schedules

48: AND designator_type = 7;
49:
50: CURSOR c_attach_scenario (l_plan_id IN NUMBER, l_dp_plan_id IN NUMBER) IS
51: SELECT count(*)
52: FROM msc_plan_schedules
53: WHERE plan_id = l_plan_id
54: AND input_schedule_id in ( SELECT scenario_id
55: FROM msd_dp_ascp_scenarios_v
56: WHERE demand_plan_id = l_dp_plan_id)

Line 141: insert into msc_plan_schedules (

137:
138: /* If default scenario is not attached to ASCP Plan Schedules, Attach the default scenario to ASCP plan */
139: IF (l_sch_count = 0) then
140:
141: insert into msc_plan_schedules (
142: PLAN_ID,
143: ORGANIZATION_ID,
144: INPUT_SCHEDULE_ID,
145: SR_INSTANCE_ID,