APPS.BEN_ENRT_PERD_FOR_PL
[Home] [Help]
| Product: | BEN - Advanced Benefits |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.BEN_ENRT_PERD_FOR_PL
|
SELECT ERP.ENRT_PERD_FOR_PL_ID
, ERP.EFFECTIVE_START_DATE
, ERP.EFFECTIVE_END_DATE
, ERP.ENRT_CVG_STRT_DT_CD
, ERP.ENRT_CVG_STRT_DT_RL
, ERP.ENRT_CVG_END_DT_CD
, ERP.ENRT_CVG_END_DT_RL
, ERP.RT_STRT_DT_CD
, ERP.RT_STRT_DT_RL
, ERP.RT_END_DT_CD
, ERP.RT_END_DT_RL
, ERP.ENRT_PERD_ID
, ERP.PL_ID
, ERP.LEE_RSN_ID
, ERP.BUSINESS_GROUP_ID
, ERP.ERP_ATTRIBUTE_CATEGORY
, ERP.ERP_ATTRIBUTE1
, ERP.ERP_ATTRIBUTE2
, ERP.ERP_ATTRIBUTE3
, ERP.ERP_ATTRIBUTE4
, ERP.ERP_ATTRIBUTE5
, ERP.ERP_ATTRIBUTE6
, ERP.ERP_ATTRIBUTE7
, ERP.ERP_ATTRIBUTE8
, ERP.ERP_ATTRIBUTE9
, ERP.ERP_ATTRIBUTE10
, ERP.ERP_ATTRIBUTE11
, ERP.ERP_ATTRIBUTE12
, ERP.ERP_ATTRIBUTE13
, ERP.ERP_ATTRIBUTE14
, ERP.ERP_ATTRIBUTE15
, ERP.ERP_ATTRIBUTE16
, ERP.ERP_ATTRIBUTE17
, ERP.ERP_ATTRIBUTE18
, ERP.ERP_ATTRIBUTE19
, ERP.ERP_ATTRIBUTE20
, ERP.ERP_ATTRIBUTE21
, ERP.ERP_ATTRIBUTE22
, ERP.ERP_ATTRIBUTE23
, ERP.ERP_ATTRIBUTE24
, ERP.ERP_ATTRIBUTE25
, ERP.ERP_ATTRIBUTE26
, ERP.ERP_ATTRIBUTE27
, ERP.ERP_ATTRIBUTE28
, ERP.ERP_ATTRIBUTE29
, ERP.ERP_ATTRIBUTE30
, ERP.LAST_UPDATE_DATE
, ERP.LAST_UPDATED_BY
, ERP.LAST_UPDATE_LOGIN
, ERP.CREATED_BY
, ERP.CREATION_DATE
, ERP.OBJECT_VERSION_NUMBER
FROM BEN_ENRT_PERD_FOR_PL_F ERP
WHERE ERP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ERP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))