Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_DSGNTR_ENRLD_CVG_V |
SELECT DEC.ROWID ROW_ID
, DEC.DSGNTR_ENRLD_CVG_ID
, DEC.EFFECTIVE_START_DATE
, DEC.EFFECTIVE_END_DATE
, DEC.DSGNTR_CRNTLY_ENRLD_FLAG
, DEC.DPNT_CVG_ELIGY_PRFL_ID
, DEC.BUSINESS_GROUP_ID
, DEC.DEC_ATTRIBUTE_CATEGORY
, DEC.DEC_ATTRIBUTE1
, DEC.DEC_ATTRIBUTE2
, DEC.DEC_ATTRIBUTE3
, DEC.DEC_ATTRIBUTE4
, DEC.DEC_ATTRIBUTE5
, DEC.DEC_ATTRIBUTE6
, DEC.DEC_ATTRIBUTE7
, DEC.DEC_ATTRIBUTE8
, DEC.DEC_ATTRIBUTE9
, DEC.DEC_ATTRIBUTE10
, DEC.DEC_ATTRIBUTE11
, DEC.DEC_ATTRIBUTE12
, DEC.DEC_ATTRIBUTE13
, DEC.DEC_ATTRIBUTE14
, DEC.DEC_ATTRIBUTE15
, DEC.DEC_ATTRIBUTE16
, DEC.DEC_ATTRIBUTE17
, DEC.DEC_ATTRIBUTE18
, DEC.DEC_ATTRIBUTE19
, DEC.DEC_ATTRIBUTE20
, DEC.DEC_ATTRIBUTE21
, DEC.DEC_ATTRIBUTE22
, DEC.DEC_ATTRIBUTE23
, DEC.DEC_ATTRIBUTE24
, DEC.DEC_ATTRIBUTE25
, DEC.DEC_ATTRIBUTE26
, DEC.DEC_ATTRIBUTE27
, DEC.DEC_ATTRIBUTE28
, DEC.DEC_ATTRIBUTE29
, DEC.DEC_ATTRIBUTE30
, DEC.LAST_UPDATE_DATE
, DEC.LAST_UPDATED_BY
, DEC.LAST_UPDATE_LOGIN
, DEC.CREATED_BY
, DEC.CREATION_DATE
, DEC.OBJECT_VERSION_NUMBER
FROM BEN_DSGNTR_ENRLD_CVG_F DEC
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN DEC.EFFECTIVE_START_DATE
AND DEC.EFFECTIVE_END_DATE