Query to get Salary Change details in Fusion HCM

 SELECT papf.person_number PERSON_NUMBER,

(select full_name from per_person_names_f ppnf

where ppnf.person_id = papf.person_id

and name_type = 'GLOBAL'

and trunc(sysdate) between ppnf.effective_start_date and ppnf.effective_end_date) person_name,

ple.name LEGAL_EMPLOYE,

(CASE 

when cs.SALARY_BASIS_CODE = 'ANNUAL'

THEN

'Salary Change' 

else 

'Hourly Rate Change'

end)  ACTION_NAME,

to_char(cs_old.salary_amount) OLD_DATA,

 to_char(CS.salary_amount) NEW_DATA  

 ,TO_CHAR(cs.date_from, 'MM/DD/YYYY') EFFECTIVE_DATE

   ,  TO_CHAR(cs.creation_date, 'MM/DD/YYYY') CHANGED_DATE

   , cs.LAST_UPDATED_BY CHANGED_BY

          from  fusion.CMP_SALARY cs,

          CMP_SALARY cs_old,

  PER_ALL_ASSIGNMENTS_M  PAAM,

  PER_ALL_PEOPLE_F PAPF

  ,per_legal_employers ple

         where 1 = 1

   AND PAPF.PERSON_ID = PAAM.PERSON_ID

   AND PAAM.ASSIGNMENT_TYPE = 'E'

   AND PAAM.PRIMARY_FLAG = 'Y'

   AND paam.legal_entity_id=ple.organization_id

   AND paam.legislation_code='US'

   AND paam.assignment_id = cs.assignment_id

         AND cs.assignment_id = cs_old.assignment_id

         AND cs.date_from= cs_old.date_to+1

         AND cs.date_from between :P_FROM_DATE and :P_TO_DATE

   AND trunc(sysdate) between paam.effective_start_date and paam.effective_end_date

   AND trunc(sysdate) between papf.effective_start_date and papf.effective_end_date