Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_RATING_LEVELS_V |
SELECT RTL.ROWID ROW_ID
, RTL.RATING_LEVEL_ID
, RTL.RATING_SCALE_ID
, RTL.COMPETENCE_ID
, RTL.BUSINESS_GROUP_ID
, RTL.STEP_VALUE
, RTX.NAME
, RTX.BEHAVIOURAL_INDICATOR
, RTL.OBJECT_VERSION_NUMBER
, RTL.ATTRIBUTE_CATEGORY
, RTL.ATTRIBUTE1
, RTL.ATTRIBUTE2
, RTL.ATTRIBUTE3
, RTL.ATTRIBUTE4
, RTL.ATTRIBUTE5
, RTL.ATTRIBUTE6
, RTL.ATTRIBUTE7
, RTL.ATTRIBUTE8
, RTL.ATTRIBUTE9
, RTL.ATTRIBUTE10
, RTL.ATTRIBUTE11
, RTL.ATTRIBUTE12
, RTL.ATTRIBUTE13
, RTL.ATTRIBUTE14
, RTL.ATTRIBUTE15
, RTL.ATTRIBUTE16
, RTL.ATTRIBUTE17
, RTL.ATTRIBUTE18
, RTL.ATTRIBUTE19
, RTL.ATTRIBUTE20
, RTL.LAST_UPDATE_DATE
, RTL.LAST_UPDATED_BY
, RTL.LAST_UPDATE_LOGIN
, RTL.CREATED_BY
, RTL.CREATION_DATE
FROM PER_RATING_LEVELS RTL
, PER_RATING_LEVELS_TL RTX
WHERE RTL.RATING_SCALE_ID IS NOT NULL
AND RTL.RATING_LEVEL_ID = RTX.RATING_LEVEL_ID
AND RTX.LANGUAGE = USERENV('LANG')