VIEW: APPS.HRFV_POSITION_EVALUATIONS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,pft.name position_name ,jeval.overall_score evaluation_score ,jeval.date_evaluated evaluation_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' ,pos.business_group_id business_group_id ,pos.position_id position_id FROM per_job_evaluations jeval ,hr_all_organization_units_tl bgrT ,per_all_positions pos ,hr_all_positions_f_tl pft WHERE jeval.position_id = pos.position_id AND pos.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND pos.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, pos.business_group_id) AND pos.position_id = pft.position_id AND pft.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PFT.NAME POSITION_NAME
, JEVAL.OVERALL_SCORE EVALUATION_SCORE
, JEVAL.DATE_EVALUATED EVALUATION_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'
, POS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, POS.POSITION_ID POSITION_ID
FROM PER_JOB_EVALUATIONS JEVAL
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_ALL_POSITIONS POS
, HR_ALL_POSITIONS_F_TL PFT
WHERE JEVAL.POSITION_ID = POS.POSITION_ID
AND POS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND POS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, POS.BUSINESS_GROUP_ID)
AND POS.POSITION_ID = PFT.POSITION_ID
AND PFT.LANGUAGE = USERENV('LANG') WITH READ ONLY