APPS.MSC_PHUB_EXCESS_PKG dependencies on MSC_PLAN_RUNS

Line 26: from msc_plan_runs

22:
23:
24: select plan_type, sr_instance_id, plan_start_date, plan_cutoff_date, temp_transfer_id
25: into l_plan_type, l_sr_instance_id, l_plan_start_date, l_plan_cutoff_date, l_transfer_id
26: from msc_plan_runs
27: where plan_id=p_plan_id
28: and plan_run_id=p_plan_run_id;
29:
30: select nvl(enforce_wrh_cpty,2)