168: SELECT DISTINCT(PF.employee_id)
169: INTO x_employee_id
170: FROM
171: bom_dept_res_instances bdri,
172: wip_operation_resources wor,
173: wip_operations wo
174: ,ahl_workorders awo, ahl_operation_resources aor
175: , mtl_employees_current_view pf
176: ,bom_resource_employees bre
270: select distinct pf.employee_id, pf.full_name
271: INTO x_employee_id, x_employee_name
272: from
273: bom_dept_res_instances bdri,
274: wip_operation_resources wor,
275: wip_operations wo
276: ,ahl_workorders awo, ahl_operation_resources aor
277: , mtl_employees_current_view pf
278: ,bom_resource_employees bre