[Home] [Help]
1573: l_pref_id number;
1574:
1575: CURSOR bkt_c(p_date date) IS
1576: select bucket_index
1577: from msc_plan_buckets mpb,
1578: msc_plans mp
1579: where mp.plan_id = arg_plan_id
1580: and mp.plan_id = mpb.plan_id
1581: and mp.organization_id = mpb.organization_id
5885: l_pref_id number;
5886:
5887: CURSOR bkt_c(p_date date) IS
5888: select bucket_index
5889: from msc_plan_buckets mpb,
5890: msc_plans mp
5891: where mp.plan_id = arg_plan_id
5892: and mp.plan_id = mpb.plan_id
5893: and mp.organization_id = mpb.organization_id