I understand that you have multiple payment types, and an employee may have several rows with different payment types.
Do ALL employees have at least one row with payment type of 'SAL'?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden