title: Query all salary details employees OCA Fusion HCM
body: <p>I am trying to write a query to obtain all employee salary details. My experience in Oracle Cloud is limited and I have mostly used MSSQL instead of Oracle SQL. However, my attempt is this:</p>
  
  <pre><code>SELECT P.Person_Number,
         A.Effective_Start_Date AS StartDateAssignment,
         SAL.Effective_Start_Date AS StartDateSalary,
         SAL.Salary_Amount,
         A.Assignment_ID,
         AR.ACTION_REASON AS Reason
  FROM Per_All_Assignments_f A
    INNER JOIN CMP_SALARY SAL ON SAL.Assignment_ID = A.Assignment_ID
    INNER JOIN Per_People_f P ON P.Person_ID = A.Person_ID
    INNER JOIN Per_Action_Reasons_TL AS AR ON AR.ACTION_REASON_ID = SAL.ACTION_REASON_ID
  </code></pre>
  
  <p>This code is incorrect (missing keyword error). Can anyone give me some tips?</p>
  
  <p>Thanks a lot!</p>
  
  <p>KR </p>