APPS.MSC_PHUB_EXCESS_PKG dependencies on MSC_PLANS

Line 32: from msc_plans

28: and plan_run_id=p_plan_run_id;
29:
30: select nvl(enforce_wrh_cpty,2)
31: into l_enforce_wh_cpty
32: from msc_plans
33: where plan_id=p_plan_id;
34:
35: msc_phub_util.log('msc_phub_excess_pkg.populate_details: '||
36: p_plan_id||','||p_plan_run_id||','||l_plan_type||','||

Line 45: from msc_plans

41:
42: begin
43: select simulation_set_id
44: into l_item_simulation_set_id
45: from msc_plans
46: where plan_id=p_plan_id;
47:
48: select plan_id
49: into l_sim_plan_id

Line 104: from msc_plans

100: from dual;
101: else
102: select item_simulation_set_id
103: into l_item_simulation_set_id
104: from msc_plans
105: where plan_id=p_plan_id;
106: end if;
107:
108: msc_phub_util.log('msc_phub_excess_pkg.populate_details: '||