FND Design Data [Home] [Help]

View: BEN_ELIG_DSBLTY_DGR_PRTE_V

Product: BEN - Advanced Benefits
Description:
Implementation/DBA Data: ViewAPPS.BEN_ELIG_DSBLTY_DGR_PRTE_V
View Text

SELECT EDD.ROWID ROW_ID
, ELIG_DSBLTY_DGR_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, DEGREE
, ORDR_NUM
, EDD.CRITERIA_SCORE
, EDD.CRITERIA_WEIGHT
, EDD_ATTRIBUTE_CATEGORY
, EDD_ATTRIBUTE1
, EDD_ATTRIBUTE2
, EDD_ATTRIBUTE3
, EDD_ATTRIBUTE4
, EDD_ATTRIBUTE5
, EDD_ATTRIBUTE6
, EDD_ATTRIBUTE7
, EDD_ATTRIBUTE8
, EDD_ATTRIBUTE9
, EDD_ATTRIBUTE10
, EDD_ATTRIBUTE11
, EDD_ATTRIBUTE12
, EDD_ATTRIBUTE13
, EDD_ATTRIBUTE14
, EDD_ATTRIBUTE15
, EDD_ATTRIBUTE16
, EDD_ATTRIBUTE17
, EDD_ATTRIBUTE18
, EDD_ATTRIBUTE19
, EDD_ATTRIBUTE20
, EDD_ATTRIBUTE21
, EDD_ATTRIBUTE22
, EDD_ATTRIBUTE23
, EDD_ATTRIBUTE24
, EDD_ATTRIBUTE25
, EDD_ATTRIBUTE26
, EDD_ATTRIBUTE27
, EDD_ATTRIBUTE28
, EDD_ATTRIBUTE29
, EDD_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DSBLTY_DGR_PRTE_F EDD
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE

Columns

Name
ROW_ID
ELIG_DSBLTY_DGR_PRTE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
ELIGY_PRFL_ID
EXCLD_FLAG
DEGREE
ORDR_NUM
CRITERIA_SCORE
CRITERIA_WEIGHT
EDD_ATTRIBUTE_CATEGORY
EDD_ATTRIBUTE1
EDD_ATTRIBUTE2
EDD_ATTRIBUTE3
EDD_ATTRIBUTE4
EDD_ATTRIBUTE5
EDD_ATTRIBUTE6
EDD_ATTRIBUTE7
EDD_ATTRIBUTE8
EDD_ATTRIBUTE9
EDD_ATTRIBUTE10
EDD_ATTRIBUTE11
EDD_ATTRIBUTE12
EDD_ATTRIBUTE13
EDD_ATTRIBUTE14
EDD_ATTRIBUTE15
EDD_ATTRIBUTE16
EDD_ATTRIBUTE17
EDD_ATTRIBUTE18
EDD_ATTRIBUTE19
EDD_ATTRIBUTE20
EDD_ATTRIBUTE21
EDD_ATTRIBUTE22
EDD_ATTRIBUTE23
EDD_ATTRIBUTE24
EDD_ATTRIBUTE25
EDD_ATTRIBUTE26
EDD_ATTRIBUTE27
EDD_ATTRIBUTE28
EDD_ATTRIBUTE29
EDD_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER