Effective end date in PER_MANAGER_HRCHY_DN not updated
Summary:
When does effective_end_date in PER_MANAGER_HRCHY_DN gets populated? We are assuming that when an employee is no longer reporting to a manager then effective_end_date in this table will be updated with end date details. Is this correct?
I am running below query to get all the direct/indirect reportee currently under this manager as of SYSDATE but the below query is returning the details of previous team members who are no longer reporting to this manager.
SELECT person_idFROM PER_MANAGER_HRCHY_DN pmhd
where pmhd.manager_id = hrc_session_util.get_user_personid
0