VIEW: APPS.BEN_ENRLD_ANTHR_PLIP_RT

Source

View Text - Preformatted

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 WHERE ear.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and ear.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

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
WHERE EAR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EAR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))