DBA Data[Home] [Help]

APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_SHIFT_DATES

Line 309: from msc_shift_dates dates,

305: changes.to_time),
306: dates.shift_date,
307: changes.shift_num,
308: changes.capacity_change
309: from msc_shift_dates dates,
310: msc_resource_changes changes
311: WHERE dates.calendar_code = v_calendar_code
312: AND dates.sr_instance_id = arg_sr_instance_id
313: AND dates.exception_set_id = v_calendar_exception_set_id

Line 494: FROM msc_shift_dates dates,

490: ,v_current_request
491: ,v_current_application
492: ,v_current_conc_program
493: ,MSC_CL_COLLECTION.v_current_date
494: FROM msc_shift_dates dates,
495: msc_shift_times shifts,
496: msc_resource_shifts res_shifts
497: WHERE dates.calendar_code = v_calendar_code
498: AND dates.sr_instance_id = arg_sr_instance_id