VIEW: APPS.BEN_PERF_RTNG_RT

Source

View Text - Preformatted

SELECT PRR.ROWID, PRR.PERF_RTNG_RT_ID, PRR.EFFECTIVE_START_DATE, PRR.EFFECTIVE_END_DATE, PRR.ORDR_NUM, PRR.EXCLD_FLAG, PRR.PERF_RTNG_CD, PRR.EVENT_TYPE, PRR.VRBL_RT_PRFL_ID, PRR.BUSINESS_GROUP_ID, PRR.OBJECT_VERSION_NUMBER, PRR.PRR_ATTRIBUTE_CATEGORY, PRR.PRR_ATTRIBUTE1 , PRR.PRR_ATTRIBUTE2 , PRR.PRR_ATTRIBUTE3 , PRR.PRR_ATTRIBUTE4 , PRR.PRR_ATTRIBUTE5 , PRR.PRR_ATTRIBUTE6 , PRR.PRR_ATTRIBUTE7 , PRR.PRR_ATTRIBUTE8 , PRR.PRR_ATTRIBUTE9 , PRR.PRR_ATTRIBUTE10 , PRR.PRR_ATTRIBUTE11 , PRR.PRR_ATTRIBUTE12 , PRR.PRR_ATTRIBUTE13 , PRR.PRR_ATTRIBUTE14 , PRR.PRR_ATTRIBUTE15 , PRR.PRR_ATTRIBUTE16 , PRR.PRR_ATTRIBUTE17 , PRR.PRR_ATTRIBUTE18 , PRR.PRR_ATTRIBUTE19 , PRR.PRR_ATTRIBUTE20 , PRR.PRR_ATTRIBUTE21 , PRR.PRR_ATTRIBUTE22 , PRR.PRR_ATTRIBUTE23 , PRR.PRR_ATTRIBUTE24 , PRR.PRR_ATTRIBUTE25 , PRR.PRR_ATTRIBUTE26 , PRR.PRR_ATTRIBUTE27 , PRR.PRR_ATTRIBUTE28 , PRR.PRR_ATTRIBUTE29 , PRR.PRR_ATTRIBUTE30 , 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 WHERE PRR.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and PRR.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT PRR.ROWID
, PRR.PERF_RTNG_RT_ID
, PRR.EFFECTIVE_START_DATE
, PRR.EFFECTIVE_END_DATE
, PRR.ORDR_NUM
, PRR.EXCLD_FLAG
, PRR.PERF_RTNG_CD
, PRR.EVENT_TYPE
, PRR.VRBL_RT_PRFL_ID
, PRR.BUSINESS_GROUP_ID
, PRR.OBJECT_VERSION_NUMBER
, PRR.PRR_ATTRIBUTE_CATEGORY
, PRR.PRR_ATTRIBUTE1
, PRR.PRR_ATTRIBUTE2
, PRR.PRR_ATTRIBUTE3
, PRR.PRR_ATTRIBUTE4
, PRR.PRR_ATTRIBUTE5
, PRR.PRR_ATTRIBUTE6
, PRR.PRR_ATTRIBUTE7
, PRR.PRR_ATTRIBUTE8
, PRR.PRR_ATTRIBUTE9
, PRR.PRR_ATTRIBUTE10
, PRR.PRR_ATTRIBUTE11
, PRR.PRR_ATTRIBUTE12
, PRR.PRR_ATTRIBUTE13
, PRR.PRR_ATTRIBUTE14
, PRR.PRR_ATTRIBUTE15
, PRR.PRR_ATTRIBUTE16
, PRR.PRR_ATTRIBUTE17
, PRR.PRR_ATTRIBUTE18
, PRR.PRR_ATTRIBUTE19
, PRR.PRR_ATTRIBUTE20
, PRR.PRR_ATTRIBUTE21
, PRR.PRR_ATTRIBUTE22
, PRR.PRR_ATTRIBUTE23
, PRR.PRR_ATTRIBUTE24
, PRR.PRR_ATTRIBUTE25
, PRR.PRR_ATTRIBUTE26
, PRR.PRR_ATTRIBUTE27
, PRR.PRR_ATTRIBUTE28
, PRR.PRR_ATTRIBUTE29
, PRR.PRR_ATTRIBUTE30
, 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
WHERE PRR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PRR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))