Employee details With Position and department

SELECT    papf.title
       || ' '
       || first_name
       || ' '
       || middle_names
       || ' '
       || last_name employee_name,
       papf.employee_number, pp.NAME POSITION,hou.name Department_name
  FROM per_all_people_f papf, per_all_assignments_f paaf, per_positions pp,hr_organization_units   hou
 WHERE papf.person_id = paaf.person_id
   AND paaf.position_id = pp.position_id
   AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date
   AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date
   and paaf.ORGANIZATION_ID=hou.ORGANIZATION_ID
   order by 2