APPS.WIP_WS_LABOR_METRIC_PUB dependencies on BOM_CALENDAR_SHIFTS

Line 325: bom_calendar_shifts bcs,

321: max(bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0)) to_time
322: from bom_shift_times bst
323: where bst.calendar_code = p_calendar_code
324: group by bst.shift_num) st,
325: bom_calendar_shifts bcs,
326: bom_resource_shifts brs
327: where bsd.calendar_code = p_calendar_code
328: and bsd.exception_set_id = -1
329: and bsd.shift_date between trunc(start_period) and trunc(end_period)