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 = P...






Comments
Post a Comment