VIEW: APPS.BEN_ENRLD_ANTHR_PTIP_RT_V

Source

View Text - Preformatted

SELECT ENT.ROWID ROW_ID, ENT.ENRLD_ANTHR_PTIP_RT_ID ,ENT.EFFECTIVE_START_DATE , ENT.EFFECTIVE_END_DATE ,ENT.ORDR_NUM ,ENT.EXCLD_FLAG ,ENT.ENRL_DET_DT_CD , ENT.ONLY_PLS_SUBJ_COBRA_FLAG ,ENT.PTIP_ID ,ENT.VRBL_RT_PRFL_ID ,ENT.BUSINESS_GROUP_ID , ENT.ENT_ATTRIBUTE_CATEGORY ,ENT.ENT_ATTRIBUTE1 ,ENT.ENT_ATTRIBUTE2 ,ENT.ENT_ATTRIBUTE3 , ENT.ENT_ATTRIBUTE4 ,ENT.ENT_ATTRIBUTE5 ,ENT.ENT_ATTRIBUTE6 ,ENT.ENT_ATTRIBUTE7 , ENT.ENT_ATTRIBUTE8 ,ENT.ENT_ATTRIBUTE9 ,ENT.ENT_ATTRIBUTE10 ,ENT.ENT_ATTRIBUTE11 , ENT.ENT_ATTRIBUTE12 ,ENT.ENT_ATTRIBUTE13 ,ENT.ENT_ATTRIBUTE14 ,ENT.ENT_ATTRIBUTE15 , ENT.ENT_ATTRIBUTE16 ,ENT.ENT_ATTRIBUTE17 ,ENT.ENT_ATTRIBUTE18 ,ENT.ENT_ATTRIBUTE19 , ENT.ENT_ATTRIBUTE20 ,ENT.ENT_ATTRIBUTE21 ,ENT.ENT_ATTRIBUTE22 ,ENT.ENT_ATTRIBUTE23 , ENT.ENT_ATTRIBUTE24 ,ENT.ENT_ATTRIBUTE25 ,ENT.ENT_ATTRIBUTE26 ,ENT.ENT_ATTRIBUTE27 , ENT.ENT_ATTRIBUTE28 ,ENT.ENT_ATTRIBUTE29 ,ENT.ENT_ATTRIBUTE30 ,ENT.LAST_UPDATE_DATE , ENT.LAST_UPDATED_BY ,ENT.LAST_UPDATE_LOGIN ,ENT.CREATED_BY ,ENT.CREATION_DATE , ENT.OBJECT_VERSION_NUMBER FROM BEN_ENRLD_ANTHR_PTIP_RT_F ENT, fnd_sessions se WHERE se.session_id = USERENV('sessionid') AND se.effective_date BETWEEN ENT.effective_start_date AND ENT.effective_end_date

View Text - HTML Formatted

SELECT ENT.ROWID ROW_ID
, ENT.ENRLD_ANTHR_PTIP_RT_ID
, ENT.EFFECTIVE_START_DATE
, ENT.EFFECTIVE_END_DATE
, ENT.ORDR_NUM
, ENT.EXCLD_FLAG
, ENT.ENRL_DET_DT_CD
, ENT.ONLY_PLS_SUBJ_COBRA_FLAG
, ENT.PTIP_ID
, ENT.VRBL_RT_PRFL_ID
, ENT.BUSINESS_GROUP_ID
, ENT.ENT_ATTRIBUTE_CATEGORY
, ENT.ENT_ATTRIBUTE1
, ENT.ENT_ATTRIBUTE2
, ENT.ENT_ATTRIBUTE3
, ENT.ENT_ATTRIBUTE4
, ENT.ENT_ATTRIBUTE5
, ENT.ENT_ATTRIBUTE6
, ENT.ENT_ATTRIBUTE7
, ENT.ENT_ATTRIBUTE8
, ENT.ENT_ATTRIBUTE9
, ENT.ENT_ATTRIBUTE10
, ENT.ENT_ATTRIBUTE11
, ENT.ENT_ATTRIBUTE12
, ENT.ENT_ATTRIBUTE13
, ENT.ENT_ATTRIBUTE14
, ENT.ENT_ATTRIBUTE15
, ENT.ENT_ATTRIBUTE16
, ENT.ENT_ATTRIBUTE17
, ENT.ENT_ATTRIBUTE18
, ENT.ENT_ATTRIBUTE19
, ENT.ENT_ATTRIBUTE20
, ENT.ENT_ATTRIBUTE21
, ENT.ENT_ATTRIBUTE22
, ENT.ENT_ATTRIBUTE23
, ENT.ENT_ATTRIBUTE24
, ENT.ENT_ATTRIBUTE25
, ENT.ENT_ATTRIBUTE26
, ENT.ENT_ATTRIBUTE27
, ENT.ENT_ATTRIBUTE28
, ENT.ENT_ATTRIBUTE29
, ENT.ENT_ATTRIBUTE30
, ENT.LAST_UPDATE_DATE
, ENT.LAST_UPDATED_BY
, ENT.LAST_UPDATE_LOGIN
, ENT.CREATED_BY
, ENT.CREATION_DATE
, ENT.OBJECT_VERSION_NUMBER
FROM BEN_ENRLD_ANTHR_PTIP_RT_F ENT
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN ENT.EFFECTIVE_START_DATE
AND ENT.EFFECTIVE_END_DATE