Employee Wise Costing Information - Organization Level

SELECT per.employee_number,
       per.full_name,
       haou.name,
       pcak.segment2 division,
       pcak.segment3 department
  FROM per_people_x per,
       per_assignments_x paaf,
       hr_all_organization_units haou,
       pay_cost_allocation_keyflex pcak
 WHERE     per.person_id = paaf.person_id
       AND paaf.primary_flag = 'Y'
       AND paaf.assignment_status_type_id IN (1, 2)
       AND paaf.assignment_type = 'E'
       AND haou.organization_id = paaf.organization_id
       AND pcak.cost_allocation_keyflex_id = haou.cost_allocation_keyflex_id