APPS.MSC_BI2EBS_PKG dependencies on MSC_PLANS

Line 203: from msc_plan_runs r, msc_plans p

199: select distinct
200: nvl(p.plan_id, r.plan_id) plan_id,
201: nvl(p.sr_instance_id, r.sr_instance_id) sr_instance_id
202: into l_plan_id, l_sr_instance_id
203: from msc_plan_runs r, msc_plans p
204: where (plan_run_name = p_params.plan_name
205: or (r.last_run_flag=1
206: and r.plan_name||' - '||fnd_message.get_string('MSC','MSC_CURRENT_TEXT')= p_params.plan_name ) )
207: and r.plan_name=p.compile_designator(+);