DBA Data[Home] [Help]

APPS.WIP_WS_PTPKPI_UTIL dependencies on MTL_PARAMETERS

Line 18: from mtl_parameters mp

14: l_calendar_code varchar2(100) := null;
15: begin
16: -- get the calendar_code based on organization_id
17: select mp.calendar_code into l_calendar_code
18: from mtl_parameters mp
19: where mp.organization_id = p_organization_id;
20: return l_calendar_code;
21: exception when others then
22: return null;

Line 224: from mtl_parameters

220: x_shift_id := null;
221: begin
222: select calendar_code
223: into l_cal_code
224: from mtl_parameters
225: where organization_id = p_org_id;
226:
227: /* find out the day that is on */
228: select min(bsd.shift_date)