VIEW: APPS.BEN_ENRLD_ANTHR_PGM_RT

Source

View Text - Preformatted

SELECT EPM.ROWID ROW_ID, EPM.ENRLD_ANTHR_PGM_RT_ID ,EPM.EFFECTIVE_START_DATE , EPM.EFFECTIVE_END_DATE ,EPM.ORDR_NUM ,EPM.EXCLD_FLAG ,EPM.ENRL_DET_DT_CD ,EPM.PGM_ID , EPM.VRBL_RT_PRFL_ID ,EPM.BUSINESS_GROUP_ID ,EPM.EPM_ATTRIBUTE_CATEGORY , EPM.EPM_ATTRIBUTE1 ,EPM.EPM_ATTRIBUTE2 ,EPM.EPM_ATTRIBUTE3 ,EPM.EPM_ATTRIBUTE4 , EPM.EPM_ATTRIBUTE5 ,EPM.EPM_ATTRIBUTE6 ,EPM.EPM_ATTRIBUTE7 ,EPM.EPM_ATTRIBUTE8 , EPM.EPM_ATTRIBUTE9 ,EPM.EPM_ATTRIBUTE10 ,EPM.EPM_ATTRIBUTE11 ,EPM.EPM_ATTRIBUTE12 , EPM.EPM_ATTRIBUTE13 ,EPM.EPM_ATTRIBUTE14 ,EPM.EPM_ATTRIBUTE15 ,EPM.EPM_ATTRIBUTE16 , EPM.EPM_ATTRIBUTE17 ,EPM.EPM_ATTRIBUTE18 ,EPM.EPM_ATTRIBUTE19 ,EPM.EPM_ATTRIBUTE20 , EPM.EPM_ATTRIBUTE21 ,EPM.EPM_ATTRIBUTE22 ,EPM.EPM_ATTRIBUTE23 ,EPM.EPM_ATTRIBUTE24 , EPM.EPM_ATTRIBUTE25 ,EPM.EPM_ATTRIBUTE26 ,EPM.EPM_ATTRIBUTE27 ,EPM.EPM_ATTRIBUTE28 , EPM.EPM_ATTRIBUTE29 ,EPM.EPM_ATTRIBUTE30 ,EPM.LAST_UPDATE_DATE ,EPM.LAST_UPDATED_BY , EPM.LAST_UPDATE_LOGIN ,EPM.CREATED_BY ,EPM.CREATION_DATE ,EPM.OBJECT_VERSION_NUMBER FROM BEN_ENRLD_ANTHR_PGM_RT_F EPM WHERE EPM.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and EPM.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT EPM.ROWID ROW_ID
, EPM.ENRLD_ANTHR_PGM_RT_ID
, EPM.EFFECTIVE_START_DATE
, EPM.EFFECTIVE_END_DATE
, EPM.ORDR_NUM
, EPM.EXCLD_FLAG
, EPM.ENRL_DET_DT_CD
, EPM.PGM_ID
, EPM.VRBL_RT_PRFL_ID
, EPM.BUSINESS_GROUP_ID
, EPM.EPM_ATTRIBUTE_CATEGORY
, EPM.EPM_ATTRIBUTE1
, EPM.EPM_ATTRIBUTE2
, EPM.EPM_ATTRIBUTE3
, EPM.EPM_ATTRIBUTE4
, EPM.EPM_ATTRIBUTE5
, EPM.EPM_ATTRIBUTE6
, EPM.EPM_ATTRIBUTE7
, EPM.EPM_ATTRIBUTE8
, EPM.EPM_ATTRIBUTE9
, EPM.EPM_ATTRIBUTE10
, EPM.EPM_ATTRIBUTE11
, EPM.EPM_ATTRIBUTE12
, EPM.EPM_ATTRIBUTE13
, EPM.EPM_ATTRIBUTE14
, EPM.EPM_ATTRIBUTE15
, EPM.EPM_ATTRIBUTE16
, EPM.EPM_ATTRIBUTE17
, EPM.EPM_ATTRIBUTE18
, EPM.EPM_ATTRIBUTE19
, EPM.EPM_ATTRIBUTE20
, EPM.EPM_ATTRIBUTE21
, EPM.EPM_ATTRIBUTE22
, EPM.EPM_ATTRIBUTE23
, EPM.EPM_ATTRIBUTE24
, EPM.EPM_ATTRIBUTE25
, EPM.EPM_ATTRIBUTE26
, EPM.EPM_ATTRIBUTE27
, EPM.EPM_ATTRIBUTE28
, EPM.EPM_ATTRIBUTE29
, EPM.EPM_ATTRIBUTE30
, EPM.LAST_UPDATE_DATE
, EPM.LAST_UPDATED_BY
, EPM.LAST_UPDATE_LOGIN
, EPM.CREATED_BY
, EPM.CREATION_DATE
, EPM.OBJECT_VERSION_NUMBER
FROM BEN_ENRLD_ANTHR_PGM_RT_F EPM
WHERE EPM.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EPM.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))