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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Not able to find relation between assignment and Grade Step in BIP Query

edited Jan 20, 2022 2:19PM in Human Capital Management 2 comments

Summary:

select PGSF.* from per_all_assignments_m PAAM, PER_GRADES_F PGD, PER_GRADE_STEPS_F PGS, PER_GRADE_STEPS_F_TL PGSF

where 

PAAM.GRADE_ID=PGD.GRADE_ID

AND PGD.GRADE_ID=PGS.GRADE_ID

and PGS.GRADE_STEP_ID=PGSF.GRADE_STEP_ID

and PAAM.person_id='100000008733781' 

and PAAM.LEGISLATION_CODE='CA'

and PGSF.LANGUAGE='US'

AND trunc(sysdate)between PAAM.effective_start_date and PAAM.effective_end_date

AND trunc(sysdate)between PGD.effective_start_date and PGD.effective_end_date

AND trunc(sysdate)between PGS.effective_start_date and PGS.effective_end_date

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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