APPS.WIP_WS_UTIL dependencies on BOM_SHIFT_DATES

Line 425: from bom_shift_dates bsd

421: end if;
422:
423: select min(bsd.shift_date)
424: into l_next_working_date
425: from bom_shift_dates bsd
426: where bsd.calendar_code = p_calendar_code
427: and bsd.shift_date > trunc(p_date,'ddd')
428: and bsd.seq_num is not null;
429:

Line 468: from bom_shift_dates bsd,

464: elsif ( p_shift_num is not null ) then
465: select bsd.shift_date + at.from_time /(24*60*60),
466: bsd.shift_date + at.to_time/(24*60*60)
467: into l_start_date, l_end_date
468: from bom_shift_dates bsd,
469: (select min(bst.from_time) from_time,
470: max(bst.to_time + decode(sign(to_time - from_time), -1, 24*60*60, 0)) to_time,
471: mp.calendar_code
472: from bom_shift_times bst, mtl_parameters mp

Line 733: from bom_shift_dates bsd, bom_resource_shifts brs,

729: Is
730: cursor c_shift_periods(p_cal_code varchar2, p_date date, p_dept_id number, p_resource_id number)
731: is
732: select bsd.shift_date, bst.from_time, bst.to_time
733: from bom_shift_dates bsd, bom_resource_shifts brs,
734: bom_shift_times bst, mtl_parameters mp
735: where mp.organization_id = p_organization_id and
736: bsd.calendar_code = p_cal_code and
737: bsd.exception_set_id = mp.calendar_exception_set_id and