DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on MTL_PARAMETERS

Line 445: from mtl_parameters

441: l_calendar_code varchar2(10);
442: begin
443: select calendar_code
444: into l_calendar_code
445: from mtl_parameters
446: where organization_id = p_org_id;
447:
448: return l_calendar_code;
449: end get_calendar_code;

Line 472: from bom_shift_times bst, mtl_parameters mp

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
473: where bst.calendar_code = mp.calendar_code and
474: mp.organization_id = p_org_id and
475: bst.shift_num = p_shift_num
476: group by mp.calendar_code

Line 734: bom_shift_times bst, mtl_parameters mp

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
738: bsd.shift_date >= trunc(p_date) - 1 and