Query to get all the mandatory fields to load payroll relationship information of an employee in Fusion HCM

 SELECT PAP.PERSON_NUMBER,
       PPN.LAST_NAME,
   PPN.FIRST_NAME,
       PAA.ASSIGNMENT_NUMBER,
   PAA.ASSIGNMENT_STATUS_TYPE,
   SUBSTR(PPO.DATE_START,1,10) AS HIRE_DATE,
   SUBSTR(PPO.ACTUAL_TERMINATION_DATE,1,10) AS TERMINATION_DATE
  FROM PER_ALL_PEOPLE_F PAP,
       PER_PERSON_NAMES_F PPN,
   PER_ALL_ASSIGNMENTS_M PAA,
   PER_PERIODS_OF_SERVICE PPO
 WHERE PAP.PERSON_ID = PPN.PERSON_ID
   AND PPN.NAME_TYPE = 'GLOBAL'
   AND PPN.PERSON_ID = PAA.PERSON_ID
   AND PAA.PERIOD_OF_SERVICE_ID = PPO.PERIOD_OF_SERVICE_ID
   AND PAA.PERSON_ID = PPO.PERSON_ID
   AND PAA.ASSIGNMENT_TYPE = 'E'
   AND PAA.ASSIGNMENT_SEQUENCE = (SELECT MAX(ASSIGNMENT_SEQUENCE)
                                    FROM PER_ALL_ASSIGNMENTS_M
   WHERE PERSON_ID = PAP.PERSON_ID
     AND ASSIGNMENT_TYPE = 'E'
AND EFFECTIVE_LATEST_CHANGE = 'Y'
AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)
   AND PAA.EFFECTIVE_LATEST_CHANGE = 'Y'
   AND TRUNC(SYSDATE) BETWEEN PAP.EFFECTIVE_START_DATE AND PAP.EFFECTIVE_END_DATE
   AND TRUNC(SYSDATE) BETWEEN PPN.EFFECTIVE_START_DATE AND PPN.EFFECTIVE_END_DATE
   AND TRUNC(SYSDATE) BETWEEN PAA.EFFECTIVE_START_DATE AND PAA.EFFECTIVE_END_DATE
 ORDER BY PAP.PERSON_NUMBER