APPS.MSC_BI2EBS_PKG dependencies on MSC_PLAN_RUNS

Line 92: select plan_id from msc_plan_runs

88: l_wnd varchar2(20);
89: l_mode number;
90:
91: cursor c_plan_id(p_plan_run_name varchar2) is
92: select plan_id from msc_plan_runs
93: where plan_run_name = p_plan_run_name;
94:
95: cursor c_org_id(p_org_name varchar2) is
96: SELECT MTP.SR_INSTANCE_ID, MTP.SR_TP_ID

Line 161: -- get plan_id from msc_plan_runs table

157: into l_resp_id,l_appl_id,l_sec_group_id
158: from dual;
159:
160: -----------------------------------------------------
161: -- get plan_id from msc_plan_runs table
162: ----------------------------------------------------
163:
164: open c_plan_id(l_plan_name);
165: fetch c_plan_id into l_plan_id;