sql query to retrieve HCM Annual Salary as of max date of (1/1, date of hire, or Effective date)

Summary:

Hi Folks,

Do you have query to retrieve HCM Annual Salary as of max date of (1/1, date of hire, or Effective date when Standard Hrs is >=20)

Thanks