Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ENRLD_ANTHR_PLIP_RT_V |
SELECT EAR.ROWID ROW_ID
, EAR.ENRLD_ANTHR_PLIP_RT_ID
, EAR.EFFECTIVE_START_DATE
, EAR.EFFECTIVE_END_DATE
, EAR.EXCLD_FLAG
, EAR.ENRL_DET_DT_CD
, EAR.ORDR_NUM
, EAR.PLIP_ID
, EAR.VRBL_RT_PRFL_ID
, EAR.BUSINESS_GROUP_ID
, EAR.EAR_ATTRIBUTE_CATEGORY
, EAR.EAR_ATTRIBUTE1
, EAR.EAR_ATTRIBUTE2
, EAR.EAR_ATTRIBUTE3
, EAR.EAR_ATTRIBUTE4
, EAR.EAR_ATTRIBUTE5
, EAR.EAR_ATTRIBUTE6
, EAR.EAR_ATTRIBUTE7
, EAR.EAR_ATTRIBUTE8
, EAR.EAR_ATTRIBUTE9
, EAR.EAR_ATTRIBUTE10
, EAR.EAR_ATTRIBUTE11
, EAR.EAR_ATTRIBUTE12
, EAR.EAR_ATTRIBUTE13
, EAR.EAR_ATTRIBUTE14
, EAR.EAR_ATTRIBUTE15
, EAR.EAR_ATTRIBUTE16
, EAR.EAR_ATTRIBUTE17
, EAR.EAR_ATTRIBUTE18
, EAR.EAR_ATTRIBUTE19
, EAR.EAR_ATTRIBUTE20
, EAR.EAR_ATTRIBUTE21
, EAR.EAR_ATTRIBUTE22
, EAR.EAR_ATTRIBUTE23
, EAR.EAR_ATTRIBUTE24
, EAR.EAR_ATTRIBUTE25
, EAR.EAR_ATTRIBUTE26
, EAR.EAR_ATTRIBUTE27
, EAR.EAR_ATTRIBUTE28
, EAR.EAR_ATTRIBUTE29
, EAR.EAR_ATTRIBUTE30
, EAR.LAST_UPDATE_DATE
, EAR.LAST_UPDATED_BY
, EAR.LAST_UPDATE_LOGIN
, EAR.CREATED_BY
, EAR.CREATION_DATE
, EAR.OBJECT_VERSION_NUMBER
FROM BEN_ENRLD_ANTHR_PLIP_RT_F EAR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EAR.EFFECTIVE_START_DATE
AND EAR.EFFECTIVE_END_DATE