VIEW: APPS.HRBV_APPRAISALS_V

Source

View Text - Preformatted

SELECT APR.APPRAISAL_DATE, APR.GROUP_DATE, APR.APPRAISAL_PERIOD_END_DATE, APR.APPRAISAL_PERIOD_START_DATE, APR.TYPE, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_TYPE',APR.TYPE), APR.NEXT_APPRAISAL_DATE, APR.STATUS, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_ASSESSMENT_STATUS',APR.STATUS), APR.COMMENTS, APR.OPEN, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',APR.OPEN), APR.SYSTEM_TYPE, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_SYS_TYPE',APR.SYSTEM_TYPE), APR.APPRAISAL_SYSTEM_STATUS, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_SYSTEM_STATUS',APR.APPRAISAL_SYSTEM_STATUS), APR.SYSTEM_PARAMS, APR.APPRAISEE_ACCESS, HR_BIS.BIS_DECODE_LOOKUP('APPRAISEE_ACCESS',APR.APPRAISEE_ACCESS), APR.ASSIGNMENT_START_DATE, APR.POTENTIAL_READINESS_LEVEL, HR_BIS.BIS_DECODE_LOOKUP('READINESS_LEVEL',APR.POTENTIAL_READINESS_LEVEL), APR.POTENTIAL_SHORT_TERM_WORKOPP, APR.POTENTIAL_LONG_TERM_WORKOPP, APR.POTENTIAL_DETAILS, '_DF:PER:PER_APPRAISALS:APR', APR.APPRAISAL_ID, APR.BUSINESS_GROUP_ID, APR.APPRAISAL_TEMPLATE_ID, APR.APPRAISEE_PERSON_ID, APR.APPRAISER_PERSON_ID, APR.GROUP_INITIATOR_ID, APR.OVERALL_PERFORMANCE_LEVEL_ID, APR.MAIN_APPRAISER_ID, APR.ASSIGNMENT_ID, APR.ASSIGNMENT_BUSINESS_GROUP_ID, APR.ASSIGNMENT_ORGANIZATION_ID, APR.ASSIGNMENT_JOB_ID, APR.ASSIGNMENT_POSITION_ID, APR.ASSIGNMENT_GRADE_ID, APR.EVENT_ID, APR.LAST_UPDATE_DATE, APR.LAST_UPDATED_BY, APR.CREATED_BY, APR.CREATION_DATE, CASE WHEN APR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, APR.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_APPRAISALS APR WITH READ ONLY

View Text - HTML Formatted

SELECT APR.APPRAISAL_DATE
, APR.GROUP_DATE
, APR.APPRAISAL_PERIOD_END_DATE
, APR.APPRAISAL_PERIOD_START_DATE
, APR.TYPE
, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_TYPE'
, APR.TYPE)
, APR.NEXT_APPRAISAL_DATE
, APR.STATUS
, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_ASSESSMENT_STATUS'
, APR.STATUS)
, APR.COMMENTS
, APR.OPEN
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, APR.OPEN)
, APR.SYSTEM_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_SYS_TYPE'
, APR.SYSTEM_TYPE)
, APR.APPRAISAL_SYSTEM_STATUS
, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_SYSTEM_STATUS'
, APR.APPRAISAL_SYSTEM_STATUS)
, APR.SYSTEM_PARAMS
, APR.APPRAISEE_ACCESS
, HR_BIS.BIS_DECODE_LOOKUP('APPRAISEE_ACCESS'
, APR.APPRAISEE_ACCESS)
, APR.ASSIGNMENT_START_DATE
, APR.POTENTIAL_READINESS_LEVEL
, HR_BIS.BIS_DECODE_LOOKUP('READINESS_LEVEL'
, APR.POTENTIAL_READINESS_LEVEL)
, APR.POTENTIAL_SHORT_TERM_WORKOPP
, APR.POTENTIAL_LONG_TERM_WORKOPP
, APR.POTENTIAL_DETAILS
, '_DF:PER:PER_APPRAISALS:APR'
, APR.APPRAISAL_ID
, APR.BUSINESS_GROUP_ID
, APR.APPRAISAL_TEMPLATE_ID
, APR.APPRAISEE_PERSON_ID
, APR.APPRAISER_PERSON_ID
, APR.GROUP_INITIATOR_ID
, APR.OVERALL_PERFORMANCE_LEVEL_ID
, APR.MAIN_APPRAISER_ID
, APR.ASSIGNMENT_ID
, APR.ASSIGNMENT_BUSINESS_GROUP_ID
, APR.ASSIGNMENT_ORGANIZATION_ID
, APR.ASSIGNMENT_JOB_ID
, APR.ASSIGNMENT_POSITION_ID
, APR.ASSIGNMENT_GRADE_ID
, APR.EVENT_ID
, APR.LAST_UPDATE_DATE
, APR.LAST_UPDATED_BY
, APR.CREATED_BY
, APR.CREATION_DATE
, CASE WHEN APR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, APR.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_APPRAISALS APR WITH READ ONLY