APPS.WIP_WS_LABOR_METRIC_PUB dependencies on BOM_CALENDAR_SHIFTS

Line 319: bom_calendar_shifts bcs,

315: max(bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0)) to_time
316: from bom_shift_times bst
317: where bst.calendar_code = p_calendar_code
318: group by bst.shift_num) st,
319: bom_calendar_shifts bcs,
320: bom_resource_shifts brs
321: where bsd.calendar_code = p_calendar_code
322: and bsd.exception_set_id = -1
323: and bsd.shift_date between trunc(start_period) and trunc(end_period)