Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_DSBLD_PRTE_V |
SELECT EDB.ROWID
, EDB.ELIG_DSBLD_PRTE_ID
, EDB.DSBLD_CD
, EDB.EFFECTIVE_START_DATE
, EDB.EFFECTIVE_END_DATE
, EDB.EXCLD_FLAG
, EDB.ELIGY_PRFL_ID
, EDB.BUSINESS_GROUP_ID
, EDB.CRITERIA_SCORE
, EDB.CRITERIA_WEIGHT
, EDB.EDB_ATTRIBUTE_CATEGORY
, EDB.EDB_ATTRIBUTE1
, EDB.EDB_ATTRIBUTE2
, EDB.EDB_ATTRIBUTE3
, EDB.EDB_ATTRIBUTE4
, EDB.EDB_ATTRIBUTE5
, EDB.EDB_ATTRIBUTE6
, EDB.EDB_ATTRIBUTE7
, EDB.EDB_ATTRIBUTE8
, EDB.EDB_ATTRIBUTE9
, EDB.EDB_ATTRIBUTE10
, EDB.EDB_ATTRIBUTE11
, EDB.EDB_ATTRIBUTE12
, EDB.EDB_ATTRIBUTE13
, EDB.EDB_ATTRIBUTE14
, EDB.EDB_ATTRIBUTE15
, EDB.EDB_ATTRIBUTE16
, EDB.EDB_ATTRIBUTE17
, EDB.EDB_ATTRIBUTE18
, EDB.EDB_ATTRIBUTE19
, EDB.EDB_ATTRIBUTE20
, EDB.EDB_ATTRIBUTE21
, EDB.EDB_ATTRIBUTE22
, EDB.EDB_ATTRIBUTE23
, EDB.EDB_ATTRIBUTE24
, EDB.EDB_ATTRIBUTE25
, EDB.EDB_ATTRIBUTE26
, EDB.EDB_ATTRIBUTE27
, EDB.EDB_ATTRIBUTE28
, EDB.EDB_ATTRIBUTE29
, EDB.EDB_ATTRIBUTE30
, EDB.LAST_UPDATE_DATE
, EDB.LAST_UPDATED_BY
, EDB.LAST_UPDATE_LOGIN
, EDB.CREATED_BY
, EDB.CREATION_DATE
, EDB.OBJECT_VERSION_NUMBER
, EDB.ORDR_NUM
FROM BEN_ELIG_DSBLD_PRTE_F EDB
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EDB.EFFECTIVE_START_DATE
AND EDB.EFFECTIVE_END_DATE