APPS.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_CALENDAR_DATES

Line 308: FROM msc_calendar_dates cal,

304: -- This cursor selects the dates for the buckets.
305: -- -------------------------------------------------
306: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
307: SELECT cal.calendar_date
308: FROM msc_calendar_dates cal,
309: msc_trading_partners tp
310: WHERE tp.sr_tp_id = arg_plan_organization_id
311: AND tp.sr_instance_id = arg_plan_instance_id
312: AND tp.calendar_exception_set_id = cal.exception_set_id

Line 416: msc_calendar_dates dates

412: FROM msc_form_query list,
413: msc_trading_partners param,
414: msc_system_items msi,
415: msc_supplies rec,
416: msc_calendar_dates dates
417: WHERE (arg_res_level = 1
418: OR (arg_res_level = 2
419: AND rec.project_id is NULL)
420: OR (DECODE(arg_res_level,

Line 605: msc_calendar_dates dates

601: 0 cost
602: FROM msc_form_query list,
603: msc_trading_partners param,
604: msc_demands mgr,
605: msc_calendar_dates dates
606: WHERE (arg_res_level = 1
607: OR (arg_res_level = 2
608: AND mgr.project_id is NULL)
609: OR (DECODE(arg_res_level,

Line 741: msc_calendar_dates dates

737: 0 cost
738: FROM msc_form_query list,
739: msc_trading_partners param,
740: msc_demands mgr,
741: msc_calendar_dates dates
742: WHERE (arg_res_level = 1
743: OR (arg_res_level = 2
744: AND mgr.project_id is NULL)
745: OR (DECODE(arg_res_level,