Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PRTN_ELIG_PRFL_X |
SELECT CEP.PRTN_ELIG_PRFL_ID
, CEP.EFFECTIVE_START_DATE
, CEP.EFFECTIVE_END_DATE
, CEP.BUSINESS_GROUP_ID
, CEP.MNDTRY_FLAG
, CEP.PRTN_ELIG_ID
, CEP.ELIGY_PRFL_ID
, CEP.COMPUTE_SCORE_FLAG
, CEP.CEP_ATTRIBUTE_CATEGORY
, CEP.CEP_ATTRIBUTE1
, CEP.CEP_ATTRIBUTE2
, CEP.CEP_ATTRIBUTE3
, CEP.CEP_ATTRIBUTE4
, CEP.CEP_ATTRIBUTE5
, CEP.CEP_ATTRIBUTE6
, CEP.CEP_ATTRIBUTE7
, CEP.CEP_ATTRIBUTE8
, CEP.CEP_ATTRIBUTE9
, CEP.CEP_ATTRIBUTE10
, CEP.CEP_ATTRIBUTE11
, CEP.CEP_ATTRIBUTE12
, CEP.CEP_ATTRIBUTE13
, CEP.CEP_ATTRIBUTE14
, CEP.CEP_ATTRIBUTE15
, CEP.CEP_ATTRIBUTE16
, CEP.CEP_ATTRIBUTE17
, CEP.CEP_ATTRIBUTE18
, CEP.CEP_ATTRIBUTE19
, CEP.CEP_ATTRIBUTE20
, CEP.CEP_ATTRIBUTE21
, CEP.CEP_ATTRIBUTE22
, CEP.CEP_ATTRIBUTE23
, CEP.CEP_ATTRIBUTE24
, CEP.CEP_ATTRIBUTE25
, CEP.CEP_ATTRIBUTE26
, CEP.CEP_ATTRIBUTE27
, CEP.CEP_ATTRIBUTE28
, CEP.CEP_ATTRIBUTE29
, CEP.CEP_ATTRIBUTE30
, CEP.LAST_UPDATE_DATE
, CEP.LAST_UPDATED_BY
, CEP.LAST_UPDATE_LOGIN
, CEP.CREATED_BY
, CEP.CREATION_DATE
, CEP.OBJECT_VERSION_NUMBER
, CEP.ELIG_PRFL_TYPE_CD
FROM BEN_PRTN_ELIG_PRFL_F CEP
WHERE TRUNC(SYSDATE) BETWEEN CEP.EFFECTIVE_START_DATE
AND CEP.EFFECTIVE_END_DATE