Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_POPL_ENRT_TYP_CYCL_V |
SELECT PET.ROWID ROW_ID
, PET.POPL_ENRT_TYP_CYCL_ID
, PET.EFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE
, PET.BUSINESS_GROUP_ID
, PET.ENRT_TYP_CYCL_CD
, PET.PL_ID
, PET.PGM_ID
, PET.PET_ATTRIBUTE_CATEGORY
, PET.PET_ATTRIBUTE1
, PET.PET_ATTRIBUTE2
, PET.PET_ATTRIBUTE3
, PET.PET_ATTRIBUTE4
, PET.PET_ATTRIBUTE5
, PET.PET_ATTRIBUTE6
, PET.PET_ATTRIBUTE7
, PET.PET_ATTRIBUTE8
, PET.PET_ATTRIBUTE9
, PET.PET_ATTRIBUTE10
, PET.PET_ATTRIBUTE11
, PET.PET_ATTRIBUTE12
, PET.PET_ATTRIBUTE13
, PET.PET_ATTRIBUTE14
, PET.PET_ATTRIBUTE15
, PET.PET_ATTRIBUTE16
, PET.PET_ATTRIBUTE17
, PET.PET_ATTRIBUTE18
, PET.PET_ATTRIBUTE19
, PET.PET_ATTRIBUTE20
, PET.PET_ATTRIBUTE21
, PET.PET_ATTRIBUTE22
, PET.PET_ATTRIBUTE23
, PET.PET_ATTRIBUTE24
, PET.PET_ATTRIBUTE25
, PET.PET_ATTRIBUTE26
, PET.PET_ATTRIBUTE27
, PET.PET_ATTRIBUTE28
, PET.PET_ATTRIBUTE29
, PET.PET_ATTRIBUTE30
, PET.LAST_UPDATE_DATE
, PET.LAST_UPDATED_BY
, PET.LAST_UPDATE_LOGIN
, PET.CREATED_BY
, PET.CREATION_DATE
, PET.OBJECT_VERSION_NUMBER
FROM BEN_POPL_ENRT_TYP_CYCL_F PET
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE