Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_ASSESSMENT_TYPES_V |
SELECT 1
, AST.ASSESSMENT_TYPE_ID
, AST.NAME
, AST.BUSINESS_GROUP_ID
, AST.DESCRIPTION
, AST.RATING_SCALE_ID
, RTL1.NAME
, AST.WEIGHTING_SCALE_ID
, RTL2.NAME
, AST.RATING_SCALE_COMMENT
, AST.WEIGHTING_SCALE_COMMENT
, AST.ASSESSMENT_CLASSIFICATION
, HR_GENERAL.DECODE_LOOKUP('ASSESSMENT_CLASSIFICATION_FORM'
, AST.ASSESSMENT_CLASSIFICATION || AST.WEIGHTING_CLASSIFICATION)
, (AST.ASSESSMENT_CLASSIFICATION || AST.WEIGHTING_CLASSIFICATION)
, AST.DISPLAY_ASSESSMENT_COMMENTS
, AST.COMMENTS
, AST.INSTRUCTIONS
, AST.WEIGHTING_CLASSIFICATION
, AST.LINE_SCORE_FORMULA
, AST.TOTAL_SCORE_FORMULA
, HR_GENERAL.DECODE_LOOKUP('ASSESSMENT_TOTAL_FORMULA'
, AST.TOTAL_SCORE_FORMULA)
, AST.DATE_FROM
, AST.DATE_TO
, AST.OBJECT_VERSION_NUMBER
, AST.ATTRIBUTE_CATEGORY
, AST.ATTRIBUTE1
, AST.ATTRIBUTE2
, AST.ATTRIBUTE3
, AST.ATTRIBUTE4
, AST.ATTRIBUTE5
, AST.ATTRIBUTE6
, AST.ATTRIBUTE7
, AST.ATTRIBUTE8
, AST.ATTRIBUTE9
, AST.ATTRIBUTE10
, AST.ATTRIBUTE11
, AST.ATTRIBUTE12
, AST.ATTRIBUTE13
, AST.ATTRIBUTE14
, AST.ATTRIBUTE15
, AST.ATTRIBUTE16
, AST.ATTRIBUTE17
, AST.ATTRIBUTE18
, AST.ATTRIBUTE19
, AST.ATTRIBUTE20
, AST.LAST_UPDATE_DATE
, AST.LAST_UPDATED_BY
, AST.LAST_UPDATE_LOGIN
, AST.CREATED_BY
, AST.CREATION_DATE
FROM PER_ASSESSMENT_TYPES AST
, PER_RATING_SCALES RSC1
, PER_RATING_SCALES RSC2
, PER_RATING_SCALES_TL RTL1
, PER_RATING_SCALES_TL RTL2
WHERE AST.RATING_SCALE_ID = RSC1.RATING_SCALE_ID (+)
AND AST.RATING_SCALE_ID = RTL1.RATING_SCALE_ID (+)
AND RTL1.LANGUAGE (+) = USERENV('LANG')
AND AST.WEIGHTING_SCALE_ID = RSC2.RATING_SCALE_ID (+)
AND AST.WEIGHTING_SCALE_ID = RTL2.RATING_SCALE_ID (+)
AND RTL2.LANGUAGE (+) = USERENV('LANG')