Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIGY_CRIT_VALUES |
SELECT ECV.ELIGY_CRIT_VALUES_ID
, ECV.ELIGY_PRFL_ID
, ECV.ELIGY_CRITERIA_ID
, ECV.EFFECTIVE_START_DATE
, ECV.EFFECTIVE_END_DATE
, ECV.ORDR_NUM
, ECV.NUMBER_VALUE1
, ECV.NUMBER_VALUE2
, ECV.CHAR_VALUE1
, ECV.CHAR_VALUE2
, ECV.DATE_VALUE1
, ECV.DATE_VALUE2
, ECV.EXCLD_FLAG
, ECV.BUSINESS_GROUP_ID
, ECV.LEGISLATION_CODE
, ECV.ECV_ATTRIBUTE_CATEGORY
, ECV.ECV_ATTRIBUTE1
, ECV.ECV_ATTRIBUTE2
, ECV.ECV_ATTRIBUTE3
, ECV.ECV_ATTRIBUTE4
, ECV.ECV_ATTRIBUTE5
, ECV.ECV_ATTRIBUTE6
, ECV.ECV_ATTRIBUTE7
, ECV.ECV_ATTRIBUTE8
, ECV.ECV_ATTRIBUTE9
, ECV.ECV_ATTRIBUTE10
, ECV.ECV_ATTRIBUTE11
, ECV.ECV_ATTRIBUTE12
, ECV.ECV_ATTRIBUTE13
, ECV.ECV_ATTRIBUTE14
, ECV.ECV_ATTRIBUTE15
, ECV.ECV_ATTRIBUTE16
, ECV.ECV_ATTRIBUTE17
, ECV.ECV_ATTRIBUTE18
, ECV.ECV_ATTRIBUTE19
, ECV.ECV_ATTRIBUTE20
, ECV.ECV_ATTRIBUTE21
, ECV.ECV_ATTRIBUTE22
, ECV.ECV_ATTRIBUTE23
, ECV.ECV_ATTRIBUTE24
, ECV.ECV_ATTRIBUTE25
, ECV.ECV_ATTRIBUTE26
, ECV.ECV_ATTRIBUTE27
, ECV.ECV_ATTRIBUTE28
, ECV.ECV_ATTRIBUTE29
, ECV.ECV_ATTRIBUTE30
, ECV.LAST_UPDATE_DATE
, ECV.LAST_UPDATED_BY
, ECV.LAST_UPDATE_LOGIN
, ECV.CREATED_BY
, ECV.CREATION_DATE
, ECV.OBJECT_VERSION_NUMBER
FROM BEN_ELIGY_CRIT_VALUES_F ECV
WHERE ECV.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV ('SESSIONID'))
AND ECV.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV ('SESSIONID'))