VIEW: APPS.BEN_COMPTNCY_RT

Source

View Text - Preformatted

SELECT CTY.ROWID, CTY.COMPTNCY_RT_ID, CTY.EFFECTIVE_START_DATE, CTY.EFFECTIVE_END_DATE, CTY.ORDR_NUM, CTY.EXCLD_FLAG, CTY.COMPETENCE_ID, CTY.RATING_LEVEL_ID, CTY.VRBL_RT_PRFL_ID, CTY.BUSINESS_GROUP_ID, CTY.OBJECT_VERSION_NUMBER, CTY.CTY_ATTRIBUTE_CATEGORY, CTY.CTY_ATTRIBUTE1 , CTY.CTY_ATTRIBUTE2 , CTY.CTY_ATTRIBUTE3 , CTY.CTY_ATTRIBUTE4 , CTY.CTY_ATTRIBUTE5 , CTY.CTY_ATTRIBUTE6 , CTY.CTY_ATTRIBUTE7 , CTY.CTY_ATTRIBUTE8 , CTY.CTY_ATTRIBUTE9 , CTY.CTY_ATTRIBUTE10 , CTY.CTY_ATTRIBUTE11 , CTY.CTY_ATTRIBUTE12 , CTY.CTY_ATTRIBUTE13 , CTY.CTY_ATTRIBUTE14 , CTY.CTY_ATTRIBUTE15 , CTY.CTY_ATTRIBUTE16 , CTY.CTY_ATTRIBUTE17 , CTY.CTY_ATTRIBUTE18 , CTY.CTY_ATTRIBUTE19 , CTY.CTY_ATTRIBUTE20 , CTY.CTY_ATTRIBUTE21 , CTY.CTY_ATTRIBUTE22 , CTY.CTY_ATTRIBUTE23 , CTY.CTY_ATTRIBUTE24 , CTY.CTY_ATTRIBUTE25 , CTY.CTY_ATTRIBUTE26 , CTY.CTY_ATTRIBUTE27 , CTY.CTY_ATTRIBUTE28 , CTY.CTY_ATTRIBUTE29 , CTY.CTY_ATTRIBUTE30 , CTY.LAST_UPDATE_DATE, CTY.LAST_UPDATED_BY , CTY.LAST_UPDATE_LOGIN, CTY.CREATED_BY , CTY.CREATION_DATE FROM BEN_COMPTNCY_RT_F CTY WHERE CTY.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and CTY.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT CTY.ROWID
, CTY.COMPTNCY_RT_ID
, CTY.EFFECTIVE_START_DATE
, CTY.EFFECTIVE_END_DATE
, CTY.ORDR_NUM
, CTY.EXCLD_FLAG
, CTY.COMPETENCE_ID
, CTY.RATING_LEVEL_ID
, CTY.VRBL_RT_PRFL_ID
, CTY.BUSINESS_GROUP_ID
, CTY.OBJECT_VERSION_NUMBER
, CTY.CTY_ATTRIBUTE_CATEGORY
, CTY.CTY_ATTRIBUTE1
, CTY.CTY_ATTRIBUTE2
, CTY.CTY_ATTRIBUTE3
, CTY.CTY_ATTRIBUTE4
, CTY.CTY_ATTRIBUTE5
, CTY.CTY_ATTRIBUTE6
, CTY.CTY_ATTRIBUTE7
, CTY.CTY_ATTRIBUTE8
, CTY.CTY_ATTRIBUTE9
, CTY.CTY_ATTRIBUTE10
, CTY.CTY_ATTRIBUTE11
, CTY.CTY_ATTRIBUTE12
, CTY.CTY_ATTRIBUTE13
, CTY.CTY_ATTRIBUTE14
, CTY.CTY_ATTRIBUTE15
, CTY.CTY_ATTRIBUTE16
, CTY.CTY_ATTRIBUTE17
, CTY.CTY_ATTRIBUTE18
, CTY.CTY_ATTRIBUTE19
, CTY.CTY_ATTRIBUTE20
, CTY.CTY_ATTRIBUTE21
, CTY.CTY_ATTRIBUTE22
, CTY.CTY_ATTRIBUTE23
, CTY.CTY_ATTRIBUTE24
, CTY.CTY_ATTRIBUTE25
, CTY.CTY_ATTRIBUTE26
, CTY.CTY_ATTRIBUTE27
, CTY.CTY_ATTRIBUTE28
, CTY.CTY_ATTRIBUTE29
, CTY.CTY_ATTRIBUTE30
, CTY.LAST_UPDATE_DATE
, CTY.LAST_UPDATED_BY
, CTY.LAST_UPDATE_LOGIN
, CTY.CREATED_BY
, CTY.CREATION_DATE
FROM BEN_COMPTNCY_RT_F CTY
WHERE CTY.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND CTY.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))