VIEW: APPS.HRBV_ASSESSMENTS_V

Source

View Text - Preformatted

SELECT ASN.GROUP_DATE, ASN.ASSESSMENT_DATE, ASN.STATUS, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_ASSESSMENT_STATUS',ASN.STATUS), ASN.ASSESSMENT_PERIOD_START_DATE, ASN.ASSESSMENT_PERIOD_END_DATE, ASN.COMMENTS, ASN.TOTAL_SCORE, '_DF:PER:PER_ASSESSMENTS:ASN', ASN.ASSESSMENT_ID, ASN.BUSINESS_GROUP_ID, ASN.PERSON_ID, ASN.ASSESSMENT_TYPE_ID, ASN.GROUP_INITIATOR_ID, ASN.ASSESSOR_PERSON_ID, ASN.ASSESSMENT_GROUP_ID, ASN.APPRAISAL_ID, ASN.LAST_UPDATE_DATE, ASN.LAST_UPDATED_BY, ASN.CREATED_BY, ASN.CREATION_DATE, CASE WHEN ASN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ASN.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_ASSESSMENTS ASN WITH READ ONLY

View Text - HTML Formatted

SELECT ASN.GROUP_DATE
, ASN.ASSESSMENT_DATE
, ASN.STATUS
, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_ASSESSMENT_STATUS'
, ASN.STATUS)
, ASN.ASSESSMENT_PERIOD_START_DATE
, ASN.ASSESSMENT_PERIOD_END_DATE
, ASN.COMMENTS
, ASN.TOTAL_SCORE
, '_DF:PER:PER_ASSESSMENTS:ASN'
, ASN.ASSESSMENT_ID
, ASN.BUSINESS_GROUP_ID
, ASN.PERSON_ID
, ASN.ASSESSMENT_TYPE_ID
, ASN.GROUP_INITIATOR_ID
, ASN.ASSESSOR_PERSON_ID
, ASN.ASSESSMENT_GROUP_ID
, ASN.APPRAISAL_ID
, ASN.LAST_UPDATE_DATE
, ASN.LAST_UPDATED_BY
, ASN.CREATED_BY
, ASN.CREATION_DATE
, CASE WHEN ASN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASN.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ASSESSMENTS ASN WITH READ ONLY