Create a list of employees and their current salary.

    FOR E IN EMPLOYEES CROSS
      SH IN SALARY_HISTORY
        OVER EMPLOYEE_ID WITH
          SH.SALARY_END MISSING
    PRINT E.LAST_NAME,
          SH.SALARY_AMOUNT
    END_FOR

    The EMPLOYEES relation contains, among other things, the name
    and employee ID of each employee. The SALARY_HISTORY relation
    contains a SALARY_AMOUNT for each salary level each employee
    has attained and the starting and ending date for each current
    salary. For the current salary, the salary ending date is
    missing. These relations share the common field, EMPLOYEE_ID.
    Therefore, you can use CROSS to join them over this field.