Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_RATING_SCALES_V |
SELECT RSC.ROWID ROW_ID
, RSC.RATING_SCALE_ID
, RSL.NAME
, RSC.BUSINESS_GROUP_ID
, RSC. OBJECT_VERSION_NUMBER
, RSL.DESCRIPTION
, RSC.TYPE
, HR_GENERAL.DECODE_LOOKUP('RATING_SCALE_TYPE'
, RSC.TYPE)
, RSC.DEFAULT_FLAG
, RSC.MIN_SCALE_STEP
, RSC.MAX_SCALE_STEP
, RSC.ATTRIBUTE_CATEGORY
, RSC.ATTRIBUTE1
, RSC.ATTRIBUTE2
, RSC.ATTRIBUTE3
, RSC.ATTRIBUTE4
, RSC.ATTRIBUTE5
, RSC.ATTRIBUTE6
, RSC.ATTRIBUTE7
, RSC.ATTRIBUTE8
, RSC.ATTRIBUTE9
, RSC.ATTRIBUTE10
, RSC.ATTRIBUTE11
, RSC.ATTRIBUTE12
, RSC.ATTRIBUTE13
, RSC.ATTRIBUTE14
, RSC.ATTRIBUTE15
, RSC.ATTRIBUTE16
, RSC.ATTRIBUTE17
, RSC.ATTRIBUTE18
, RSC.ATTRIBUTE19
, RSC.ATTRIBUTE20
, RSC.LAST_UPDATE_DATE
, RSC.LAST_UPDATED_BY
, RSC.LAST_UPDATE_LOGIN
, RSC.CREATED_BY
, RSC.CREATION_DATE
, DECODE(RSC.BUSINESS_GROUP_ID
, NULL
, 'Y'
, 'N')
FROM PER_RATING_SCALES RSC
, PER_RATING_SCALES_TL RSL
WHERE RSC. RATING_SCALE_ID = RSL.RATING_SCALE_ID
AND RSL.LANGUAGE = USERENV('LANG')