Need help with fetching the data for Salary Components
We came across a very weird issue with the Salary Component data stored in the table: CMP_SALARY_PAY_COMPONENTS. where the data is not matching with what we see online.
Below is the Hosing Allowance data that we see online which is Zero.
But the data in backend table is showing, 3000
I ran the below query for your reference:
Select B.NAME,SALARY_DATE_FROM, SALARY_DATE_TO, RATE_AMOUNT from CMP_SALARY_PAY_COMPONENTS A, PAY_RATE_DEFINITIONS_F_VL B
where Assignment_ID = 300000030288782
AND PAY_RATE_DEFINITION_ID = 300000019161534
AND A.PAY_RATE_DEFINITION_ID = B.RATE_DEFINITION_ID