How to get the latest employee record from per_people_f?
We get the latest employee validity information using this table and join the employee_number from this table to other tables to get the required data. However, for few records, we have person_id, as well as the object_version_number same. How to find the active and valid record from this data that can be used in any sql?