VIEW: APPS.BEN_ELIG_PERF_RTNG_PRTE_X

Source

View Text - Preformatted

SELECT ERG.ROWID, ERG.ELIG_PERF_RTNG_PRTE_ID, ERG.EFFECTIVE_START_DATE, ERG.EFFECTIVE_END_DATE, ERG.ORDR_NUM, ERG.EXCLD_FLAG, ERG.PERF_RTNG_CD, ERG.EVENT_TYPE, ERG.ELIGY_PRFL_ID, ERG.BUSINESS_GROUP_ID, ERG.OBJECT_VERSION_NUMBER, ERG.CRITERIA_SCORE, ERG.CRITERIA_WEIGHT, ERG.ERG_ATTRIBUTE_CATEGORY, ERG.ERG_ATTRIBUTE1 , ERG.ERG_ATTRIBUTE2 , ERG.ERG_ATTRIBUTE3 , ERG.ERG_ATTRIBUTE4 , ERG.ERG_ATTRIBUTE5 , ERG.ERG_ATTRIBUTE6 , ERG.ERG_ATTRIBUTE7 , ERG.ERG_ATTRIBUTE8 , ERG.ERG_ATTRIBUTE9 , ERG.ERG_ATTRIBUTE10 , ERG.ERG_ATTRIBUTE11 , ERG.ERG_ATTRIBUTE12 , ERG.ERG_ATTRIBUTE13 , ERG.ERG_ATTRIBUTE14 , ERG.ERG_ATTRIBUTE15 , ERG.ERG_ATTRIBUTE16 , ERG.ERG_ATTRIBUTE17 , ERG.ERG_ATTRIBUTE18 , ERG.ERG_ATTRIBUTE19 , ERG.ERG_ATTRIBUTE20 , ERG.ERG_ATTRIBUTE21 , ERG.ERG_ATTRIBUTE22 , ERG.ERG_ATTRIBUTE23 , ERG.ERG_ATTRIBUTE24 , ERG.ERG_ATTRIBUTE25 , ERG.ERG_ATTRIBUTE26 , ERG.ERG_ATTRIBUTE27 , ERG.ERG_ATTRIBUTE28 , ERG.ERG_ATTRIBUTE29 , ERG.ERG_ATTRIBUTE30 , 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 WHERE TRUNC(SYSDATE) BETWEEN ERG.EFFECTIVE_START_DATE AND ERG.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT ERG.ROWID
, ERG.ELIG_PERF_RTNG_PRTE_ID
, ERG.EFFECTIVE_START_DATE
, ERG.EFFECTIVE_END_DATE
, ERG.ORDR_NUM
, ERG.EXCLD_FLAG
, ERG.PERF_RTNG_CD
, ERG.EVENT_TYPE
, ERG.ELIGY_PRFL_ID
, ERG.BUSINESS_GROUP_ID
, ERG.OBJECT_VERSION_NUMBER
, ERG.CRITERIA_SCORE
, ERG.CRITERIA_WEIGHT
, ERG.ERG_ATTRIBUTE_CATEGORY
, ERG.ERG_ATTRIBUTE1
, ERG.ERG_ATTRIBUTE2
, ERG.ERG_ATTRIBUTE3
, ERG.ERG_ATTRIBUTE4
, ERG.ERG_ATTRIBUTE5
, ERG.ERG_ATTRIBUTE6
, ERG.ERG_ATTRIBUTE7
, ERG.ERG_ATTRIBUTE8
, ERG.ERG_ATTRIBUTE9
, ERG.ERG_ATTRIBUTE10
, ERG.ERG_ATTRIBUTE11
, ERG.ERG_ATTRIBUTE12
, ERG.ERG_ATTRIBUTE13
, ERG.ERG_ATTRIBUTE14
, ERG.ERG_ATTRIBUTE15
, ERG.ERG_ATTRIBUTE16
, ERG.ERG_ATTRIBUTE17
, ERG.ERG_ATTRIBUTE18
, ERG.ERG_ATTRIBUTE19
, ERG.ERG_ATTRIBUTE20
, ERG.ERG_ATTRIBUTE21
, ERG.ERG_ATTRIBUTE22
, ERG.ERG_ATTRIBUTE23
, ERG.ERG_ATTRIBUTE24
, ERG.ERG_ATTRIBUTE25
, ERG.ERG_ATTRIBUTE26
, ERG.ERG_ATTRIBUTE27
, ERG.ERG_ATTRIBUTE28
, ERG.ERG_ATTRIBUTE29
, ERG.ERG_ATTRIBUTE30
, 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
WHERE TRUNC(SYSDATE) BETWEEN ERG.EFFECTIVE_START_DATE
AND ERG.EFFECTIVE_END_DATE