APPS.MSC_RESOURCE_PKG dependencies on MSC_PLAN_RUNS

Line 27: from msc_plan_runs

23: errbuf := null;
24:
25: select plan_type, sr_instance_id, plan_start_date, plan_cutoff_date, temp_transfer_id
26: into l_plan_type, l_sr_instance_id, l_plan_start_date, l_plan_cutoff_date, l_transfer_id
27: from msc_plan_runs
28: where plan_id=p_plan_id
29: and plan_run_id=p_plan_run_id;
30:
31: -- ODS plan

Line 36: from msc_plan_runs

32: if p_plan_id = -1
33: then
34: -- get refresh_mode
35: select refresh_mode into l_refresh_mode
36: from msc_plan_runs
37: where plan_run_id = p_plan_run_id;
38:
39: if l_refresh_mode = 2 -- targeted refesh
40: then