Is it possible to get the [Salary End Date] of an employee in their existing assignment?

Summary:

Hi all,

Is it possible to get the Salary End Date of an employee in their existing assignment?

The requirement is we need to identify if the employee has a future dated salary row, if they do have - there would be an error message whenever they try to do a global transfer on that employee.

I've tried to create a POC but I can't traverse to the correct table.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):