APPS.MSC_SDA_PKG dependencies on MSC_PLAN_BUCKETS

Line 563: from msc_plan_buckets

559: sum(decode(bucket_type, 2, 1,0)) week_buckets,
560: sum(decode(bucket_type, 3, 1,0)) period_buckets,
561: min(decode(bucket_type, 2, bkt_start_date)) week_start_date,
562: min(decode(bucket_type, 3, bkt_start_date)) pr_start_date
563: from msc_plan_buckets
564: where plan_id = g_plan_id
565: and sr_instance_id = g_owning_inst_id
566: and organization_id = g_owning_org_id;
567:

Line 572: from msc_plan_buckets

568: cursor c_plan_bucket_dates_cur is
569: select bkt_start_date,
570: bkt_end_date,
571: bucket_type
572: from msc_plan_buckets
573: where plan_id = g_plan_id
574: and sr_instance_id = g_owning_inst_id
575: and organization_id = g_owning_org_id
576: union all

Line 1938: msc_plan_buckets mpb,

1934: 0 old_quantity
1935: from
1936: msc_analysis_aggregate maa,
1937: msc_analysis_query maq,
1938: msc_plan_buckets mpb,
1939: msc_form_query mfq1, -- org-list
1940: msc_form_query mfq2 -- item-list
1941: where maq.query_id = p_query_id
1942: and maq.parent_row_index = g_next_rowset_index

Line 1979: msc_plan_buckets mpb,

1975: 0 old_quantity
1976: from
1977: msc_analysis_aggregate maa,
1978: msc_analysis_query maq,
1979: msc_plan_buckets mpb,
1980: msc_form_query mfq1, -- org-list
1981: msc_form_query mfq2 -- item-list
1982: where maq.query_id = p_query_id
1983: and maq.parent_row_index = g_next_rowset_index