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 1615: from mtl_parameters mp

1611: Begin
1612:
1613: select mp.calendar_code, mp.calendar_exception_set_id
1614: into l_cal_code, l_cal_exception_id
1615: from mtl_parameters mp
1616: where mp.organization_id = p_org_id;
1617:
1618: if( p_shift_num is not null) then
1619: /* use bom_shift_dates*/

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

1814: Begin
1815: Begin
1816: select bsd.seq_num
1817: into l_shift_seq
1818: from bom_shift_dates bsd, mtl_parameters mp, bom_resource_shifts brs
1819: where mp.organization_id = p_org_id and
1820: mp.calendar_code = bsd.calendar_code and
1821: brs.department_id = p_department_id and
1822: brs.resource_id = p_resource_id and