Change Amount and Annual Salary in HCM Extract

Summary

Change Amount and Annual Salary in HCM Extract

Content

Hi All,

We have the below 2 columns created in a BIP SQL Query report.

1. For ANNUAL_FT_SALARY, in the SQL Query we have used , "CMP_FF_DBI_PKG.GET_ANNUAL_FT_SALARY_AMOUNT(PAAF.ASSIGNMENT_ID, SYSDATE)" 

2. For CHANGE_AMOUNT, in SQL Query we have used the below content to get the change amount.

(SELECT SUM(CSC.CHANGE_AMOUNT) 

FROM CMP_SALARY_COMPONENTS CSC ,CMP_SALARY_BASES CSB, CMP_SALARY CS1 

WHERE CSC.COMPONENT_REASON_CODE <> 'LB_BASE_PAY'  

AND CS1.ASSIGNMENT_ID = CS.ASSIGNMENT_ID  

AND CS1.SALARY_BASIS_ID = CSB.SALARY_BASIS_ID