You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
11
Views
1
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!