[Home] [Help]
View: PER_JOB_POS_GRADES_LOV_V
View Text
SELECT GDT.NAME GRADE_NAME
, JBT.NAME JOB_NAME
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(JVG.POSITION_ID) POS_NAME
, JVG.GRADE_ID
, JVG.BUSINESS_GROUP_ID
, JVG.JOB_ID
, JVG.POSITION_ID
FROM PER_VALID_GRADES JVG
, PER_GRADES_TL GDT
, PER_JOBS_TL JBT
WHERE JVG.GRADE_ID = GDT.GRADE_ID
AND JVG.JOB_ID = JBT.JOB_ID (+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND GDT.LANGUAGE =USERENV('LANG')
Columns
Name |
GRADE_NAME |
JOB_NAME |
POS_NAME |
GRADE_ID |
BUSINESS_GROUP_ID |
JOB_ID |
POSITION_ID |