View: PER_JOB_POS_GRADES_LOV_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.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