Error message to compare Maximum Salary and Grade
I would like to compare Maximum Salary and Grade and show an error to the user depending on this conditional.
I created an autocomplete rule but I can´t compare the "job requisition.Maximum Salary" attribute with the grade ranges that I have in PER_RATE_VALUES_F PRV table.
Then, I would like to know:
1) Is it possible to create an autocomplete rule with error or warning messages when the budget salary in the req is less than the grade range?
2) Is it possible to use SQL in AutoComplete to show an error message, the same SQL that I have in Data Model?