Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ENRLD_ANTHR_PTIP_RT_X |
SELECT ENT.ROWID ROW_ID
, ENT.ENRLD_ANTHR_PTIP_RT_ID
, ENT.EFFECTIVE_START_DATE
, ENT.EFFECTIVE_END_DATE
, ENT.ORDR_NUM
, ENT.EXCLD_FLAG
, ENT.ENRL_DET_DT_CD
, ENT.ONLY_PLS_SUBJ_COBRA_FLAG
, ENT.PTIP_ID
, ENT.VRBL_RT_PRFL_ID
, ENT.BUSINESS_GROUP_ID
, ENT.ENT_ATTRIBUTE_CATEGORY
, ENT.ENT_ATTRIBUTE1
, ENT.ENT_ATTRIBUTE2
, ENT.ENT_ATTRIBUTE3
, ENT.ENT_ATTRIBUTE4
, ENT.ENT_ATTRIBUTE5
, ENT.ENT_ATTRIBUTE6
, ENT.ENT_ATTRIBUTE7
, ENT.ENT_ATTRIBUTE8
, ENT.ENT_ATTRIBUTE9
, ENT.ENT_ATTRIBUTE10
, ENT.ENT_ATTRIBUTE11
, ENT.ENT_ATTRIBUTE12
, ENT.ENT_ATTRIBUTE13
, ENT.ENT_ATTRIBUTE14
, ENT.ENT_ATTRIBUTE15
, ENT.ENT_ATTRIBUTE16
, ENT.ENT_ATTRIBUTE17
, ENT.ENT_ATTRIBUTE18
, ENT.ENT_ATTRIBUTE19
, ENT.ENT_ATTRIBUTE20
, ENT.ENT_ATTRIBUTE21
, ENT.ENT_ATTRIBUTE22
, ENT.ENT_ATTRIBUTE23
, ENT.ENT_ATTRIBUTE24
, ENT.ENT_ATTRIBUTE25
, ENT.ENT_ATTRIBUTE26
, ENT.ENT_ATTRIBUTE27
, ENT.ENT_ATTRIBUTE28
, ENT.ENT_ATTRIBUTE29
, ENT.ENT_ATTRIBUTE30
, ENT.LAST_UPDATE_DATE
, ENT.LAST_UPDATED_BY
, ENT.LAST_UPDATE_LOGIN
, ENT.CREATED_BY
, ENT.CREATION_DATE
, ENT.OBJECT_VERSION_NUMBER
FROM BEN_ENRLD_ANTHR_PTIP_RT_F ENT
WHERE TRUNC(SYSDATE) BETWEEN ENT.EFFECTIVE_START_DATE
AND ENT.EFFECTIVE_END_DATE