DBA Data[Home] [Help]

APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_RESOURCE_SHIFTS

Line 430: msc_resource_shifts res_shifts

426: ,v_current_application
427: ,v_current_conc_program
428: ,MSC_CL_COLLECTION.v_current_date
429: FROM
430: msc_resource_shifts res_shifts
431: WHERE
432: res_shifts.department_id = arg_department_id
433: AND res_shifts.resource_id = arg_resource_id
434: AND res_shifts.sr_instance_id = arg_sr_instance_id;

Line 496: msc_resource_shifts res_shifts,

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: (select distinct department_id, resource_id,
498: sr_instance_id, simulation_set,
499: from_date, shift_num,action_type
500: From MSC_RESOURCE_CHANGES