Query to get active employee details in Oracle APPS

SELECT ppf.employee_number

      ,ppf.full_name

  ,ppf.email_address

  FROM per_all_people_f ppf

 WHERE ppf.current_employee_flag = 'Y'

   AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date

                           AND ppf.effective_end_date

   AND ppf.employee_number IS NOT NULL

   AND ppf.person_type_id =

              (SELECT person_type_id

                 FROM per_person_types

                WHERE user_person_type = 'Employee'

                  AND business_group_id = ppf.business_group_id

  )