APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_CALENDAR_DATES

Line 178: FROM msc_calendar_dates cal,

174: -- This cursor selects the dates for the buckets.
175: -- -------------------------------------------------
176: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
177: SELECT cal.calendar_date
178: FROM msc_calendar_dates cal,
179: msc_trading_partners tp
180: WHERE tp.sr_tp_id = G_org_id
181: AND tp.sr_instance_id = G_inst_id
182: AND tp.calendar_exception_set_id = cal.exception_set_id

Line 265: msc_calendar_dates dates

261: gmp_pdr_items_gtmp gpi,
262: msc_trading_partners param,
263: -- msc_system_items msi,
264: msc_supplies rec,
265: msc_calendar_dates dates
266: WHERE /*(arg_res_level = 1
267: OR (arg_res_level = 2
268: AND rec.project_id is NULL)
269: OR (DECODE(arg_res_level,

Line 443: msc_calendar_dates dates

439: FROM -- msc_form_query list,
440: gmp_pdr_items_gtmp gpi,
441: msc_trading_partners param,
442: msc_demands mgr,
443: msc_calendar_dates dates
444: WHERE /*(arg_res_level = 1
445: OR (arg_res_level = 2
446: AND mgr.project_id is NULL)
447: OR (DECODE(arg_res_level,

Line 575: msc_calendar_dates dates

571: FROM --msc_form_query list,
572: gmp_pdr_items_gtmp gpi,
573: msc_trading_partners param,
574: msc_demands mgr,
575: msc_calendar_dates dates
576: WHERE /*(arg_res_level = 1
577: OR (arg_res_level = 2
578: AND mgr.project_id is NULL)
579: OR (DECODE(arg_res_level,