DBA Data[Home] [Help]

APPS.WIP_WS_DL_UTIL dependencies on MTL_PARAMETERS

Line 426: from mtl_parameters mp

422: end if;
423:
424: select mp.calendar_code
425: into l_cal_code
426: from mtl_parameters mp
427: where mp.organization_id = p_org_id;
428:
429: if( p_resource_id is not null ) then
430: select bdr.available_24_hours_flag

Line 1598: from mtl_parameters mp

1594: Begin
1595:
1596: select mp.calendar_code, mp.calendar_exception_set_id
1597: into l_cal_code, l_cal_exception_id
1598: from mtl_parameters mp
1599: where mp.organization_id = p_org_id;
1600:
1601: if( p_shift_num is not null) then
1602: /* use bom_shift_dates*/

Line 1798: from bom_shift_dates bsd, mtl_parameters mp, bom_resource_shifts brs

1794: Begin
1795: Begin
1796: select bsd.seq_num
1797: into l_shift_seq
1798: from bom_shift_dates bsd, mtl_parameters mp, bom_resource_shifts brs
1799: where mp.organization_id = p_org_id and
1800: mp.calendar_code = bsd.calendar_code and
1801: brs.department_id = p_department_id and
1802: brs.resource_id = p_resource_id and