VIEW: APPS.BEN_ELIG_CBR_QUALD_BNF_X

Source

View Text - Preformatted

SELECT 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 WHERE trunc(sysdate) between ecq.effective_start_date and ecq.effective_end_date

View Text - HTML Formatted

SELECT 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
WHERE TRUNC(SYSDATE) BETWEEN ECQ.EFFECTIVE_START_DATE
AND ECQ.EFFECTIVE_END_DATE