View: HRFV_JOB_EVALUATIONS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_JOB_EVALUATIONS

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, JOBS.NAME JOB_NAME
, JEVAL.OVERALL_SCORE EVALUATED_SCORE
, JEVAL.DATE_EVALUATED EVALUATED_DATE
, HR_BIS.BIS_DECODE_LOOKUP('EVAL_SYSTEM_MEAS'
, JEVAL.MEASURED_IN) MEASURED_IN
, HR_BIS.BIS_DECODE_LOOKUP('EVAL_SYSTEM'
, JEVAL.SYSTEM) SYSTEM
, '_DF:PER:PER_JOB_EVALUATIONS:JEVAL'
, JOBS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, JOBS.JOB_ID JOB_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOB_EVALUATIONS JEVAL
, PER_JOBS JOBS
WHERE JOBS.JOB_ID = JEVAL.JOB_ID
AND JOBS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND JOBS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, JOBS.BUSINESS_GROUP_ID) WITH READ ONLY

Columns