DBA Data[Home] [Help]

APPS.MSC_BUDGET_DETAILS dependencies on MSC_PLAN_BUCKETS

Line 28: from msc_plan_buckets

24: and nvl(detail_level,3) = nvl(p_bucket_type, 3);
25:
26: cursor get_bucket_dates is
27: select bkt_start_date, bkt_end_date, decode(bucket_type,2,1,3,3)
28: from msc_plan_buckets
29: where plan_id = p_plan_id
30: and p_date between bkt_start_date and bkt_end_date;
31:
32: cursor bis_inv_details_plan_c(l_tot_inv number, -- get the values from mbid