VIEW: APPS.BEN_PERF_RTNG_RT_D

Source

View Text - Preformatted

SELECT PRR.PERF_RTNG_RT_ID, PRR.EFFECTIVE_START_DATE, PRR.EFFECTIVE_END_DATE , HR1.MEANING, HR2.MEANING, PRR.EXCLD_FLAG , PRR.BUSINESS_GROUP_ID, PRR.VRBL_RT_PRFL_ID , PRR.OBJECT_VERSION_NUMBER , PRR.ORDR_NUM , PRR.LAST_UPDATE_DATE, PRR.LAST_UPDATED_BY , PRR.LAST_UPDATE_LOGIN, PRR.CREATED_BY , PRR.CREATION_DATE FROM BEN_PERF_RTNG_RT_F PRR, FND_USER_VIEW FUSER, HR_LOOKUPS HR1, HR_LOOKUPS HR2 WHERE FUSER.USER_ID(+) = PRR.LAST_UPDATED_BY and HR1.LOOKUP_CODE(+) = PRR.EVENT_TYPE and HR1.LOOKUP_TYPE(+) = 'EMP_INTERVIEW_TYPE' and HR2.LOOKUP_CODE(+) = PRR.PERF_RTNG_CD and HR2.LOOKUP_TYPE(+) = 'PERFORMANCE_RATING'

View Text - HTML Formatted

SELECT PRR.PERF_RTNG_RT_ID
, PRR.EFFECTIVE_START_DATE
, PRR.EFFECTIVE_END_DATE
, HR1.MEANING
, HR2.MEANING
, PRR.EXCLD_FLAG
, PRR.BUSINESS_GROUP_ID
, PRR.VRBL_RT_PRFL_ID
, PRR.OBJECT_VERSION_NUMBER
, PRR.ORDR_NUM
, PRR.LAST_UPDATE_DATE
, PRR.LAST_UPDATED_BY
, PRR.LAST_UPDATE_LOGIN
, PRR.CREATED_BY
, PRR.CREATION_DATE
FROM BEN_PERF_RTNG_RT_F PRR
, FND_USER_VIEW FUSER
, HR_LOOKUPS HR1
, HR_LOOKUPS HR2
WHERE FUSER.USER_ID(+) = PRR.LAST_UPDATED_BY
AND HR1.LOOKUP_CODE(+) = PRR.EVENT_TYPE
AND HR1.LOOKUP_TYPE(+) = 'EMP_INTERVIEW_TYPE'
AND HR2.LOOKUP_CODE(+) = PRR.PERF_RTNG_CD
AND HR2.LOOKUP_TYPE(+) = 'PERFORMANCE_RATING'