APPS.MSC_SUPPLY_PKG dependencies on MSC_PLAN_RUNS

Line 54: from msc_plan_runs

50: if p_plan_id = -1
51: then
52: -- get refresh_mode
53: select refresh_mode into l_refresh_mode
54: from msc_plan_runs
55: where plan_run_id = p_plan_run_id;
56:
57: if l_refresh_mode = 2 -- targeted refesh
58: then

Line 88: from msc_plan_runs

84: -- initial there is no error message
85:
86: select plan_type, sr_instance_id
87: into l_plan_type, l_sr_instance_id
88: from msc_plan_runs
89: where plan_id=p_plan_id
90: and plan_run_id=p_plan_run_id;
91:
92: select trunc(plan_start_date), trunc(plan_cutoff_date)

Line 94: from msc_plan_runs

90: and plan_run_id=p_plan_run_id;
91:
92: select trunc(plan_start_date), trunc(plan_cutoff_date)
93: into l_plan_start_date, l_plan_cutoff_date
94: from msc_plan_runs
95: where plan_run_id = p_plan_run_id;
96:
97: if (l_plan_type=1) then
98: l_pegging_granularity := nvl(fnd_profile.value('MSC_APCC_END_ITEM_ENABLED'), 2);