VIEW: APPS.HRBV_ASSESSMENT_TYPES_V

Source

View Text - Preformatted

SELECT AST.NAME, AST.DATE_TO, AST.DATE_FROM, AST.ASSESSMENT_CLASSIFICATION, HR_BIS.BIS_DECODE_LOOKUP('ASSESSMENT_CLASSIFICATION',AST.ASSESSMENT_CLASSIFICATION), AST.DISPLAY_ASSESSMENT_COMMENTS, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',AST.DISPLAY_ASSESSMENT_COMMENTS), AST.DESCRIPTION, AST.RATING_SCALE_COMMENT, AST.WEIGHTING_SCALE_COMMENT, AST.COMMENTS, AST.INSTRUCTIONS, AST.LINE_SCORE_FORMULA, HR_BIS.BIS_DECODE_LOOKUP('ASSESSMENT_LINE_FORMULA',AST.LINE_SCORE_FORMULA), AST.TOTAL_SCORE_FORMULA, HR_BIS.BIS_DECODE_LOOKUP('ASSESSMENT_TOTAL_FORMULA',AST.TOTAL_SCORE_FORMULA), AST.WEIGHTING_CLASSIFICATION, HR_BIS.BIS_DECODE_LOOKUP('ASSESSMENT_CLASSIFICATION',AST.WEIGHTING_CLASSIFICATION), '_DF:PER:PER_ASSESSMENT_TYPES:AST', AST.ASSESSMENT_TYPE_ID, AST.BUSINESS_GROUP_ID, AST.RATING_SCALE_ID, AST.WEIGHTING_SCALE_ID, AST.LAST_UPDATE_DATE, AST.LAST_UPDATED_BY, AST.CREATED_BY, AST.CREATION_DATE, CASE WHEN AST.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, AST.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_ASSESSMENT_TYPES AST WITH READ ONLY

View Text - HTML Formatted

SELECT AST.NAME
, AST.DATE_TO
, AST.DATE_FROM
, AST.ASSESSMENT_CLASSIFICATION
, HR_BIS.BIS_DECODE_LOOKUP('ASSESSMENT_CLASSIFICATION'
, AST.ASSESSMENT_CLASSIFICATION)
, AST.DISPLAY_ASSESSMENT_COMMENTS
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, AST.DISPLAY_ASSESSMENT_COMMENTS)
, AST.DESCRIPTION
, AST.RATING_SCALE_COMMENT
, AST.WEIGHTING_SCALE_COMMENT
, AST.COMMENTS
, AST.INSTRUCTIONS
, AST.LINE_SCORE_FORMULA
, HR_BIS.BIS_DECODE_LOOKUP('ASSESSMENT_LINE_FORMULA'
, AST.LINE_SCORE_FORMULA)
, AST.TOTAL_SCORE_FORMULA
, HR_BIS.BIS_DECODE_LOOKUP('ASSESSMENT_TOTAL_FORMULA'
, AST.TOTAL_SCORE_FORMULA)
, AST.WEIGHTING_CLASSIFICATION
, HR_BIS.BIS_DECODE_LOOKUP('ASSESSMENT_CLASSIFICATION'
, AST.WEIGHTING_CLASSIFICATION)
, '_DF:PER:PER_ASSESSMENT_TYPES:AST'
, AST.ASSESSMENT_TYPE_ID
, AST.BUSINESS_GROUP_ID
, AST.RATING_SCALE_ID
, AST.WEIGHTING_SCALE_ID
, AST.LAST_UPDATE_DATE
, AST.LAST_UPDATED_BY
, AST.CREATED_BY
, AST.CREATION_DATE
, CASE WHEN AST.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, AST.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ASSESSMENT_TYPES AST WITH READ ONLY