[Home] [Help]
239: /* Added for Bug 6908314. This SQL will default employee_id from badge_id. */
240: update wip_time_entry_interface wtei
241: set wtei.employee_id = ( select bre.person_id
242: from per_all_people_f papf,
243: bom_resource_employees bre
244: where papf.person_id = bre.person_id
245: and sysdate between papf.effective_start_date and nvl(papf.effective_end_date,sysdate+1)
246: and bre.organization_id = wtei.organization_id
247: and nvl(papf.employee_number,papf.npw_number) = wtei.badge_id
260: No need as we don't currently support Emp and CW having same badge in same org from MES UI.
261: update wip_time_entry_interface wtei
262: set wtei.employee_id = ( select bre.person_id
263: from per_all_people_f papf,
264: bom_resource_employees bre
265: where papf.person_id = bre.person_id
266: and sysdate between papf.effective_start_date and nvl(papf.effective_end_date,sysdate+1)
267: and bre.organization_id = wtei.organization_id
268: and papf.npw_number = wtei.badge_id
674: l_stmt_num :=160;
675: Begin
676: select min(bre.instance_id)
677: into l_instance_id
678: from bom_resource_employees bre
679: where bre.organization_id = l_wip_time_intf_tbl(l_counter).organization_id
680: and bre.resource_id = l_wip_time_intf_tbl(l_counter).resource_id
681: and bre.person_id = l_wip_time_intf_tbl(l_counter).employee_id;
682: Exception
833: begin
834: if p_dep_id is not null then
835: select count(1)
836: into l_count
837: from bom_resource_employees bre,
838: bom_department_resources bdr
839: where bdr.department_id = p_dep_id
840: and bdr.resource_id = p_res_id
841: and bdr.resource_id = bre.resource_id
843: and bre.person_id = p_emp_id;
844: else
845: select count(1)
846: into l_count
847: from bom_resource_employees bre
848: where bre.organization_id = p_org_id
849: and bre.person_id = p_emp_id
850: and bre.resource_id = nvl(p_res_id,bre.resource_id);
851: end if;