VIEW: APPS.PER_JOB_POS_GRADES_LOV_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')