VIEW: APPS.HRFV_JOB_EVALUATIONS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,jbt.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 ,per_jobs_tl jbt 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) AND jobs.job_id = jbt.job_id AND jbt.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, JBT.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
, PER_JOBS_TL JBT
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)
AND JOBS.JOB_ID = JBT.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG') WITH READ ONLY