APPS.AHL_PRD_WORKORDER_PVT dependencies on MTL_EMPLOYEES_CURRENT_VIEW

Line 7922: FROM mtl_employees_current_view pf, bom_resource_employees bre, fnd_user fu

7918: AND UPPER(PF.FULL_NAME) like UPPER(p_emp_name);
7919: */
7920:
7921: SELECT DISTINCT bre.person_id, fu.user_id
7922: FROM mtl_employees_current_view pf, bom_resource_employees bre, fnd_user fu
7923: WHERE pf.employee_id=bre.person_id
7924: and pf.organization_id = bre.organization_id
7925: and sysdate between BRE.EFFECTIVE_START_DATE and BRE.EFFECTIVE_END_DATE
7926: and FU.employee_id = pf.employee_id