DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on MTL_EMPLOYEES_CURRENT_VIEW

Line 200: from mtl_employees_current_view mec

196:
197: if( l_resource_type = 2 ) then /* for labor, try get the employee id and num */
198: select mec.employee_num
199: into l_employee_num
200: from mtl_employees_current_view mec
201: where mec.employee_id = p_employee_id
202: and mec.organization_id = p_organization_id;
203: l_employee_id := p_employee_id;
204: else

Line 1167: from wip_resource_actual_times wrat, mtl_employees_current_view mec

1163: But resource charging will not be allowed.*/
1164: begin
1165: select wrat.employee_id, mec.employee_num
1166: into l_employee_id, l_employee_num
1167: from wip_resource_actual_times wrat, mtl_employees_current_view mec
1168: where wrat.time_entry_id = l_entry_id
1169: and wrat.employee_id = mec.employee_id
1170: and wrat.organization_id = mec.organization_id;
1171: exception