Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PRTN_ELIGY_RL_X |
SELECT CER.PRTN_ELIGY_RL_ID
, CER.EFFECTIVE_START_DATE
, CER.EFFECTIVE_END_DATE
, CER.BUSINESS_GROUP_ID
, CER.PRTN_ELIG_ID
, CER.FORMULA_ID
, CER.DRVBL_FCTR_APLS_FLAG
, CER.MNDTRY_FLAG
, CER.ORDR_TO_APLY_NUM
, CER.CER_ATTRIBUTE_CATEGORY
, CER.CER_ATTRIBUTE1
, CER.CER_ATTRIBUTE2
, CER.CER_ATTRIBUTE3
, CER.CER_ATTRIBUTE4
, CER.CER_ATTRIBUTE5
, CER.CER_ATTRIBUTE6
, CER.CER_ATTRIBUTE7
, CER.CER_ATTRIBUTE8
, CER.CER_ATTRIBUTE9
, CER.CER_ATTRIBUTE10
, CER.CER_ATTRIBUTE11
, CER.CER_ATTRIBUTE12
, CER.CER_ATTRIBUTE13
, CER.CER_ATTRIBUTE14
, CER.CER_ATTRIBUTE15
, CER.CER_ATTRIBUTE16
, CER.CER_ATTRIBUTE17
, CER.CER_ATTRIBUTE18
, CER.CER_ATTRIBUTE19
, CER.CER_ATTRIBUTE20
, CER.CER_ATTRIBUTE21
, CER.CER_ATTRIBUTE22
, CER.CER_ATTRIBUTE23
, CER.CER_ATTRIBUTE24
, CER.CER_ATTRIBUTE25
, CER.CER_ATTRIBUTE26
, CER.CER_ATTRIBUTE27
, CER.CER_ATTRIBUTE28
, CER.CER_ATTRIBUTE29
, CER.CER_ATTRIBUTE30
, CER.LAST_UPDATE_DATE
, CER.LAST_UPDATED_BY
, CER.LAST_UPDATE_LOGIN
, CER.CREATED_BY
, CER.CREATION_DATE
, CER.OBJECT_VERSION_NUMBER
FROM BEN_PRTN_ELIGY_RL_F CER
WHERE TRUNC(SYSDATE) BETWEEN CER.EFFECTIVE_START_DATE
AND CER.EFFECTIVE_END_DATE