[Home] [Help]
View: HRFV_POSITION_EVALUATIONS
Product: | PER - Human Resources |
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: |
APPS.HRFV_POSITION_EVALUATIONS
|
View Text
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, POS.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
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) WITH READ ONLY
Columns
Name |
BUSINESS_GROUP_NAME |
POSITION_NAME |
EVALUATION_SCORE |
EVALUATION_DATE |
MEASURED_IN |
SYSTEM |
"_DF" |
BUSINESS_GROUP_ID |
POSITION_ID |