APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_CALENDAR_DATES

Line 183: FROM msc_calendar_dates cal,

179: -- This cursor selects the dates for the buckets.
180: -- -------------------------------------------------
181: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
182: SELECT cal.calendar_date
183: FROM msc_calendar_dates cal,
184: msc_trading_partners tp
185: WHERE tp.sr_tp_id = G_org_id
186: AND tp.sr_instance_id = G_inst_id
187: AND tp.calendar_exception_set_id = cal.exception_set_id

Line 277: msc_calendar_dates dates

273: gmp_pdr_items_gtmp gpi,
274: msc_trading_partners param,
275: -- msc_system_items msi,
276: msc_supplies rec,
277: msc_calendar_dates dates
278: WHERE /*(arg_res_level = 1
279: OR (arg_res_level = 2
280: AND rec.project_id is NULL)
281: OR (DECODE(arg_res_level,

Line 454: msc_calendar_dates dates

450: FROM -- msc_form_query list,
451: gmp_pdr_items_gtmp gpi,
452: msc_trading_partners param,
453: msc_demands mgr,
454: msc_calendar_dates dates
455: WHERE /*(arg_res_level = 1
456: OR (arg_res_level = 2
457: AND mgr.project_id is NULL)
458: OR (DECODE(arg_res_level,

Line 588: msc_calendar_dates dates

584: FROM --msc_form_query list,
585: gmp_pdr_items_gtmp gpi,
586: msc_trading_partners param,
587: msc_demands mgr,
588: msc_calendar_dates dates
589: WHERE /*(arg_res_level = 1
590: OR (arg_res_level = 2
591: AND mgr.project_id is NULL)
592: OR (DECODE(arg_res_level,