APPS.MSC_PHUB_PKG dependencies on MSC_PLANS

Line 381: (select compile_designator from msc_plans where plan_id=p.copy_plan_id)) plan_name,

377: else
378: select
379: p.plan_id,
380: decode(nvl(copy_plan_id,-1), -1, compile_designator,
381: (select compile_designator from msc_plans where plan_id=p.copy_plan_id)) plan_name,
382: p.description plan_description,
383: (case when p.curr_plan_type in (101,102,103,105) then 101
384: when p.plan_type in (1,2,3) then 1
385: else nvl(p.plan_type, -1) end) plan_type,

Line 393: from msc_plans p,

389: trunc(nvl(b.bkt_end_date, p.curr_cutoff_date)) plan_cutoff_date,
390: nvl(p.plan_completion_date, sysdate) plan_completion_date,
391: null publisher
392: into l_pi
393: from msc_plans p,
394: (select plan_id, min(bkt_start_date) bkt_start_date, max(bkt_end_date) bkt_end_date
395: from msc_plan_buckets
396: where curr_flag=1
397: group by plan_id

Line 686: from msc_plans

682: -- validate inputs
683: if (l_pi.plan_type in (1,4,8)) then
684: select nvl(display_kpi,1)
685: into l_display_kpi
686: from msc_plans
687: where plan_id=l_pi.plan_id;
688:
689: if (l_display_kpi=2) then
690: msc_phub_util.log('msc_phub_pkg.populate_details_fn: (l_pi.plan_type in (1,4,8) and l_display_kpi=2)');

Line 1381: msc_plans p

1377: (select distinct sr_instance_id, pegging_sr_category_id
1378: from msc_apcc_item_d
1379: where plan_id=p_plan_id
1380: ) c4,
1381: msc_plans p
1382: where b.sr_category_id=c1.sr_category_id1(+)
1383: and b.sr_category_id=c2.sr_category_id2(+)
1384: and b.sr_category_id=c3.sr_category_id3(+)
1385: and b.sr_category_id=c4.pegging_sr_category_id(+)

Line 1839: from msc_plans

1835:
1836: -- prepare plan info
1837: select compile_designator, description
1838: into l_pi.plan_name, l_pi.plan_description
1839: from msc_plans
1840: where plan_id=-1;
1841:
1842: select organization_id
1843: into l_pi.organization_id