APPS.MSC_BI2EBS_PKG dependencies on MSC_PLAN_RUNS

Line 196: -- get plan_id from msc_plan_runs table

192: into l_resp_id,l_appl_id,l_sec_group_id
193: from dual;
194:
195: -----------------------------------------------------
196: -- get plan_id from msc_plan_runs table
197: ----------------------------------------------------
198:
199: select distinct
200: nvl(p.plan_id, r.plan_id) plan_id,

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(+);