VIEW: APPS.BEN_ENRT_PERD_FOR_PL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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