Query to get Total Active Employees in the company in Core HR

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)