VIEW: APPS.HRBV_JOB_EVALUATIONS_V

Source

View Text - Preformatted

SELECT PJE.COMMENTS, PJE.DATE_EVALUATED, PJE.MEASURED_IN, HR_BIS.BIS_DECODE_LOOKUP('EVAL_SYSTEM_MEAS',PJE.MEASURED_IN), PJE.OVERALL_SCORE, PJE.SYSTEM, HR_BIS.BIS_DECODE_LOOKUP('EVAL_SYSTEM',PJE.SYSTEM), '_DF:PER:PER_JOB_EVALUATIONS:PJE', PJE.JOB_EVALUATION_ID, PJE.BUSINESS_GROUP_ID, PJE.JOB_ID, PJE.POSITION_ID, PJE.LAST_UPDATE_DATE, PJE.LAST_UPDATED_BY, PJE.CREATED_BY, PJE.CREATION_DATE, CASE WHEN PJE.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PJE.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_JOB_EVALUATIONS PJE WITH READ ONLY

View Text - HTML Formatted

SELECT PJE.COMMENTS
, PJE.DATE_EVALUATED
, PJE.MEASURED_IN
, HR_BIS.BIS_DECODE_LOOKUP('EVAL_SYSTEM_MEAS'
, PJE.MEASURED_IN)
, PJE.OVERALL_SCORE
, PJE.SYSTEM
, HR_BIS.BIS_DECODE_LOOKUP('EVAL_SYSTEM'
, PJE.SYSTEM)
, '_DF:PER:PER_JOB_EVALUATIONS:PJE'
, PJE.JOB_EVALUATION_ID
, PJE.BUSINESS_GROUP_ID
, PJE.JOB_ID
, PJE.POSITION_ID
, PJE.LAST_UPDATE_DATE
, PJE.LAST_UPDATED_BY
, PJE.CREATED_BY
, PJE.CREATION_DATE
, CASE WHEN PJE.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PJE.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_JOB_EVALUATIONS PJE WITH READ ONLY