APPS.MSC_SCN_UTILS dependencies on MSC_PLAN_RUNS

Line 1876: from msc_plan_runs

1872: where scenario_id=p_plan_id and p_plan_type=10;
1873:
1874: cursor c_plan_name_arch is
1875: select plan_run_name
1876: from msc_plan_runs
1877: where plan_id=p_plan_id and
1878: plan_run_id = p_plan_run_id;
1879:
1880: cursor c_end_date is

Line 1882: from msc_plan_runs

1878: plan_run_id = p_plan_run_id;
1879:
1880: cursor c_end_date is
1881: select end_date
1882: from msc_plan_runs
1883: where plan_run_id = p_plan_run_id;
1884:
1885: l_plan_name varchar2(80);
1886: l_plan_name_arch varchar2(80);

Line 1942: from msc_plan_runs

1938:
1939: FUNCTION get_plan_version(p_plan_run_id in number) return varchar2 is
1940: cursor c_end_date is
1941: select end_date
1942: from msc_plan_runs
1943: where plan_run_id = p_plan_run_id;
1944:
1945: l_pln_version varchar2(30);
1946: l_end_date date;

Line 2435: msc_plan_runs mpr,

2431: 'MSC_SCN_PLAN_STATUS',
2432: decode(upper(fcr.status_code),'C',4,'E',3)
2433: ) plan_status_display
2434: from msc_plans mp,
2435: msc_plan_runs mpr,
2436: fnd_concurrent_requests fcr
2437: where mp.plan_type is not null and
2438: mp.plan_id = mpr.plan_id and
2439: mpr.end_date is not null and