DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on BOM_RESOURCE_SHIFTS

Line 774: from bom_shift_dates bsd, bom_resource_shifts brs,

770: Is
771: cursor c_shift_periods(p_cal_code varchar2, p_date date, p_dept_id number, p_resource_id number)
772: is
773: select bsd.shift_date, bst.from_time, bst.to_time
774: from bom_shift_dates bsd, bom_resource_shifts brs,
775: bom_shift_times bst, mtl_parameters mp
776: where mp.organization_id = p_organization_id and
777: bsd.calendar_code = p_cal_code and
778: bsd.exception_set_id = mp.calendar_exception_set_id and