In this post we will see on Query to get HRMS Person type of Employees in Oracle Apps R12, this query will give employees full details with certain columns employee name, number, start date, end date and person type in Oracle apps R12. Important Table of Employee person type in Oracle Apps R12 PER_ALL_PEOPLE_F per_person_type_usages_f