APPS.MSC_SDA_PKG dependencies on MSC_PLAN_BUCKETS

Line 551: from msc_plan_buckets

547: sum(decode(bucket_type, 2, 1,0)) week_buckets,
548: sum(decode(bucket_type, 3, 1,0)) period_buckets,
549: min(decode(bucket_type, 2, bkt_start_date)) week_start_date,
550: min(decode(bucket_type, 3, bkt_start_date)) pr_start_date
551: from msc_plan_buckets
552: where plan_id = g_plan_id
553: and sr_instance_id = g_owning_inst_id
554: and organization_id = g_owning_org_id;
555:

Line 560: from msc_plan_buckets

556: cursor c_plan_bucket_dates_cur is
557: select bkt_start_date,
558: bkt_end_date,
559: bucket_type
560: from msc_plan_buckets
561: where plan_id = g_plan_id
562: and sr_instance_id = g_owning_inst_id
563: and organization_id = g_owning_org_id
564: union all

Line 1725: msc_plan_buckets mpb,

1721: 0 old_quantity
1722: from
1723: msc_analysis_aggregate maa,
1724: msc_analysis_query maq,
1725: msc_plan_buckets mpb,
1726: msc_form_query mfq1, -- org-list
1727: msc_form_query mfq2 -- item-list
1728: where maq.query_id = p_query_id
1729: and maq.parent_row_index = g_next_rowset_index

Line 1766: msc_plan_buckets mpb,

1762: 0 old_quantity
1763: from
1764: msc_analysis_aggregate maa,
1765: msc_analysis_query maq,
1766: msc_plan_buckets mpb,
1767: msc_form_query mfq1, -- org-list
1768: msc_form_query mfq2 -- item-list
1769: where maq.query_id = p_query_id
1770: and maq.parent_row_index = g_next_rowset_index