View: BEN_COMPTNCY_RT

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_COMPTNCY_RT

View Text

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'))

Columns