Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_VALID_GRADES_V |
SELECT PVG.VALID_GRADE_ID
, PVG.ROWID
, PVG.BUSINESS_GROUP_ID
, PVG.GRADE_ID
, GDT.NAME
, PVG.DATE_FROM
, PVG.COMMENTS
, PVG.DATE_TO
, PVG.JOB_ID
, PVG.POSITION_ID
, PVG.REQUEST_ID
, PVG.PROGRAM_APPLICATION_ID
, PVG.PROGRAM_ID
, PVG.PROGRAM_UPDATE_DATE
, PVG.ATTRIBUTE_CATEGORY
, PVG.ATTRIBUTE1
, PVG.ATTRIBUTE2
, PVG.ATTRIBUTE3
, PVG.ATTRIBUTE4
, PVG.ATTRIBUTE5
, PVG.ATTRIBUTE6
, PVG.ATTRIBUTE7
, PVG.ATTRIBUTE8
, PVG.ATTRIBUTE9
, PVG.ATTRIBUTE10
, PVG.ATTRIBUTE11
, PVG.ATTRIBUTE12
, PVG.ATTRIBUTE13
, PVG.ATTRIBUTE14
, PVG.ATTRIBUTE15
, PVG.ATTRIBUTE16
, PVG.ATTRIBUTE17
, PVG.ATTRIBUTE18
, PVG.ATTRIBUTE19
, PVG.ATTRIBUTE20
, PVG.LAST_UPDATE_DATE
, PVG.LAST_UPDATED_BY
, PVG.LAST_UPDATE_LOGIN
, PVG.CREATED_BY
, PVG.CREATION_DATE
FROM PER_VALID_GRADES PVG
, PER_GRADES_TL GDT
WHERE PVG.GRADE_ID = GDT.GRADE_ID
AND GDT.LANGUAGE = USERENV('LANG')