Using Compensation Default and Override Fast Formula to access Value Set information

Summary:

We are using a value set to fetch grade id of employees at different stages of a cycle (employees having several work relationships).

Content (required):

Query:

select paaf.grade_id

from per_all_assignments_f paaf

where 1=1

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

and paaf.person_id=:{PARAMETER.PERSON_ID}

Now in Compensation module, we are using a Compensation Default and Override formula to pick up the grade id from this value set.