View: BEN_ELIG_DSBLTY_CTG_PRTE_V

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

View Text

SELECT ECT.ROWID ROW_ID
, ELIG_DSBLTY_CTG_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, CATEGORY
, ORDR_NUM
, ECT.CRITERIA_SCORE
, ECT.CRITERIA_WEIGHT
, ECT_ATTRIBUTE_CATEGORY
, ECT_ATTRIBUTE1
, ECT_ATTRIBUTE2
, ECT_ATTRIBUTE3
, ECT_ATTRIBUTE4
, ECT_ATTRIBUTE5
, ECT_ATTRIBUTE6
, ECT_ATTRIBUTE7
, ECT_ATTRIBUTE8
, ECT_ATTRIBUTE9
, ECT_ATTRIBUTE10
, ECT_ATTRIBUTE11
, ECT_ATTRIBUTE12
, ECT_ATTRIBUTE13
, ECT_ATTRIBUTE14
, ECT_ATTRIBUTE15
, ECT_ATTRIBUTE16
, ECT_ATTRIBUTE17
, ECT_ATTRIBUTE18
, ECT_ATTRIBUTE19
, ECT_ATTRIBUTE20
, ECT_ATTRIBUTE21
, ECT_ATTRIBUTE22
, ECT_ATTRIBUTE23
, ECT_ATTRIBUTE24
, ECT_ATTRIBUTE25
, ECT_ATTRIBUTE26
, ECT_ATTRIBUTE27
, ECT_ATTRIBUTE28
, ECT_ATTRIBUTE29
, ECT_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DSBLTY_CTG_PRTE_F ECT
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE

Columns