Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_ENRLD_ANTHR_PTIP_X |
SELECT EET.ELIG_ENRLD_ANTHR_PTIP_ID
, EET.EFFECTIVE_START_DATE
, EET.EFFECTIVE_END_DATE
, EET.ORDR_NUM
, EET.EXCLD_FLAG
, EET.ENRL_DET_DT_CD
, EET.ONLY_PLS_SUBJ_COBRA_FLAG
, EET.PTIP_ID
, EET.ELIGY_PRFL_ID
, EET.BUSINESS_GROUP_ID
, EET.EET_ATTRIBUTE_CATEGORY
, EET.EET_ATTRIBUTE1
, EET.EET_ATTRIBUTE2
, EET.EET_ATTRIBUTE3
, EET.EET_ATTRIBUTE4
, EET.EET_ATTRIBUTE5
, EET.EET_ATTRIBUTE6
, EET.EET_ATTRIBUTE7
, EET.EET_ATTRIBUTE8
, EET.EET_ATTRIBUTE9
, EET.EET_ATTRIBUTE10
, EET.EET_ATTRIBUTE11
, EET.EET_ATTRIBUTE12
, EET.EET_ATTRIBUTE13
, EET.EET_ATTRIBUTE14
, EET.EET_ATTRIBUTE15
, EET.EET_ATTRIBUTE16
, EET.EET_ATTRIBUTE17
, EET.EET_ATTRIBUTE18
, EET.EET_ATTRIBUTE19
, EET.EET_ATTRIBUTE20
, EET.EET_ATTRIBUTE21
, EET.EET_ATTRIBUTE22
, EET.EET_ATTRIBUTE23
, EET.EET_ATTRIBUTE24
, EET.EET_ATTRIBUTE25
, EET.EET_ATTRIBUTE26
, EET.EET_ATTRIBUTE27
, EET.EET_ATTRIBUTE28
, EET.EET_ATTRIBUTE29
, EET.EET_ATTRIBUTE30
, EET.LAST_UPDATE_DATE
, EET.LAST_UPDATED_BY
, EET.LAST_UPDATE_LOGIN
, EET.CREATED_BY
, EET.CREATION_DATE
, EET.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_ENRLD_ANTHR_PTIP_F EET
WHERE TRUNC(SYSDATE) BETWEEN EET.EFFECTIVE_START_DATE
AND EET.EFFECTIVE_END_DATE