SQL Query not fetching the latest adjustment Amount in Salary change
Content
Hi
I used the following query to fetch the salary adjustment details which include component details. However, it does not fetch the latest salary change details. I am not sure what I am missing.
SELECT NAME.DISPLAY_NAME ,P.PERSON_NUMBER,SAL.ANNUAL_SALARY , SAL.SALARY_AMOUNT , SAL.ADJUSTMENT_PERCENT, SAL.ADJUSTMENT_AMOUNT,
CMP.COMPONENT_REASON_CODE AS COMPONENT_NAME ,CMP.CHANGE_AMOUNT AS COMPONENT_CHANGE_AMOUNT, CMP.CHANGE_PERCENTAGE AS COMPONENT_CHANGE_PERCENTAGE
FROM CMP_SALARY SAL , CMP_SALARY_COMPONENTS CMP , per_all_assignments_m M , PER_ALL_PEOPLE_F P ,PER_PERSON_NAMES_F NAME
WHERE SAL.ASSIGNMENT_ID = CMP.ASSIGNMENT_ID