Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_CBR_QUALD_BNF_V |
SELECT ECQ.ROWID ROW_ID
, ECQ.ELIG_CBR_QUALD_BNF_ID
, ECQ.EFFECTIVE_START_DATE
, ECQ.EFFECTIVE_END_DATE
, ECQ.QUALD_BNF_FLAG
, ECQ.ORDR_NUM
, ECQ.ELIGY_PRFL_ID
, ECQ.PGM_ID
, ECQ.PTIP_ID
, ECQ.BUSINESS_GROUP_ID
, ECQ.CRITERIA_SCORE
, ECQ.CRITERIA_WEIGHT
, ECQ.ECQ_ATTRIBUTE_CATEGORY
, ECQ.ECQ_ATTRIBUTE1
, ECQ.ECQ_ATTRIBUTE2
, ECQ.ECQ_ATTRIBUTE3
, ECQ.ECQ_ATTRIBUTE4
, ECQ.ECQ_ATTRIBUTE5
, ECQ.ECQ_ATTRIBUTE6
, ECQ.ECQ_ATTRIBUTE7
, ECQ.ECQ_ATTRIBUTE8
, ECQ.ECQ_ATTRIBUTE9
, ECQ.ECQ_ATTRIBUTE10
, ECQ.ECQ_ATTRIBUTE11
, ECQ.ECQ_ATTRIBUTE12
, ECQ.ECQ_ATTRIBUTE13
, ECQ.ECQ_ATTRIBUTE14
, ECQ.ECQ_ATTRIBUTE15
, ECQ.ECQ_ATTRIBUTE16
, ECQ.ECQ_ATTRIBUTE17
, ECQ.ECQ_ATTRIBUTE18
, ECQ.ECQ_ATTRIBUTE19
, ECQ.ECQ_ATTRIBUTE20
, ECQ.ECQ_ATTRIBUTE21
, ECQ.ECQ_ATTRIBUTE22
, ECQ.ECQ_ATTRIBUTE23
, ECQ.ECQ_ATTRIBUTE24
, ECQ.ECQ_ATTRIBUTE25
, ECQ.ECQ_ATTRIBUTE26
, ECQ.ECQ_ATTRIBUTE27
, ECQ.ECQ_ATTRIBUTE28
, ECQ.ECQ_ATTRIBUTE29
, ECQ.ECQ_ATTRIBUTE30
, ECQ.LAST_UPDATE_DATE
, ECQ.LAST_UPDATED_BY
, ECQ.LAST_UPDATE_LOGIN
, ECQ.CREATED_BY
, ECQ.CREATION_DATE
, ECQ.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_CBR_QUALD_BNF_F ECQ
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN ECQ.EFFECTIVE_START_DATE
AND ECQ.EFFECTIVE_END_DATE