View: BEN_ENRT_PERD_FOR_PL_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_ENRT_PERD_FOR_PL_V

View Text

SELECT ERP.ROWID ROW_ID
, 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
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN ERP.EFFECTIVE_START_DATE
AND ERP.EFFECTIVE_END_DATE

Columns