DBA Data[Home] [Help]

VIEW: APPS.BEN_ELIG_PERF_RTNG_PRTE_D

Source

View Text - Preformatted

SELECT ERG.ELIG_PERF_RTNG_PRTE_ID, ERG.EFFECTIVE_START_DATE, ERG.EFFECTIVE_END_DATE , ERG.PERF_RTNG_CD, ERG.EXCLD_FLAG , ERG.EVENT_TYPE , ERG.BUSINESS_GROUP_ID, ERG.ELIGY_PRFL_ID , ERG.OBJECT_VERSION_NUMBER , ERG.ORDR_NUM , ERG.CRITERIA_SCORE, ERG.CRITERIA_WEIGHT, ERG.LAST_UPDATE_DATE, ERG.LAST_UPDATED_BY , ERG.LAST_UPDATE_LOGIN, ERG.CREATED_BY , ERG.CREATION_DATE FROM BEN_ELIG_PERF_RTNG_PRTE_F ERG, FND_USER_VIEW FUSER WHERE FUSER.USER_ID(+) = ERG.LAST_UPDATED_BY
View Text - HTML Formatted

SELECT ERG.ELIG_PERF_RTNG_PRTE_ID
, ERG.EFFECTIVE_START_DATE
, ERG.EFFECTIVE_END_DATE
, ERG.PERF_RTNG_CD
, ERG.EXCLD_FLAG
, ERG.EVENT_TYPE
, ERG.BUSINESS_GROUP_ID
, ERG.ELIGY_PRFL_ID
, ERG.OBJECT_VERSION_NUMBER
, ERG.ORDR_NUM
, ERG.CRITERIA_SCORE
, ERG.CRITERIA_WEIGHT
, ERG.LAST_UPDATE_DATE
, ERG.LAST_UPDATED_BY
, ERG.LAST_UPDATE_LOGIN
, ERG.CREATED_BY
, ERG.CREATION_DATE
FROM BEN_ELIG_PERF_RTNG_PRTE_F ERG
, FND_USER_VIEW FUSER
WHERE FUSER.USER_ID(+) = ERG.LAST_UPDATED_BY