APPS.MSC_ITEM_PKG dependencies on MSC_PLAN_RUNS

Line 35: from msc_plan_runs

31: if p_plan_id=-1
32: then
33: -- get plan_cutoff_date
34: select trunc(plan_cutoff_date) into l_plan_cutoff_date
35: from msc_plan_runs
36: where plan_run_id=p_plan_run_id;
37:
38: -- get refresh_mode
39: select refresh_mode into l_refresh_mode

Line 40: from msc_plan_runs

36: where plan_run_id=p_plan_run_id;
37:
38: -- get refresh_mode
39: select refresh_mode into l_refresh_mode
40: from msc_plan_runs
41: where plan_run_id=p_plan_run_id;
42:
43: if l_refresh_mode=2 -- targeted refesh
44: then

Line 71: from msc_plan_runs

67: end if;
68:
69: select plan_type, sr_instance_id, plan_start_date, plan_cutoff_date, temp_transfer_id
70: into l_plan_type, l_sr_instance_id, l_plan_start_date, l_plan_cutoff_date, l_transfer_id
71: from msc_plan_runs
72: where plan_id=p_plan_id
73: and plan_run_id=p_plan_run_id;
74:
75: l_plan_days := (l_plan_cutoff_date - l_plan_start_date + 1);