Using Compensation Default and Override Fast Formula to access Value Set information
We are using a value set to fetch grade id of employees at different stages of a cycle (employees having several work relationships).
from per_all_assignments_f paaf
AND paaf.effective_latest_change = 'Y'
AND paaf.assignment_type IN ('E','C')
AND paaf.ASSIGNMENT_STATUS_TYPE = 'ACTIVE'
AND to_date(TO_CHAR(SYSDATE,'YYYY') || '0630' , 'YYYYMMDD') BETWEEN paaf.EFFECTIVE_START_DATE AND paaf.EFFECTIVE_END_DATE
Now in Compensation module, we are using a Compensation Default and Override formula to pick up the grade id from this value set.