VIEW: APPS.BEN_DPNT_CVRD_PLIP_RT

Source

View Text - Preformatted

SELECT DCP.ROWID ROW_ID, DCP.DPNT_CVRD_PLIP_RT_ID , DCP.EFFECTIVE_START_DATE , DCP.EFFECTIVE_END_DATE , DCP.ORDR_NUM , DCP.EXCLD_FLAG , DCP.ENRL_DET_DT_CD , DCP.BUSINESS_GROUP_ID , DCP.VRBL_RT_PRFL_ID , DCP.PLIP_ID , DCP.DCP_ATTRIBUTE_CATEGORY , DCP.DCP_ATTRIBUTE1 , DCP.DCP_ATTRIBUTE2 , DCP.DCP_ATTRIBUTE3 , DCP.DCP_ATTRIBUTE4 , DCP.DCP_ATTRIBUTE5 , DCP.DCP_ATTRIBUTE6 , DCP.DCP_ATTRIBUTE7 , DCP.DCP_ATTRIBUTE8 , DCP.DCP_ATTRIBUTE9 , DCP.DCP_ATTRIBUTE10 , DCP.DCP_ATTRIBUTE11 , DCP.DCP_ATTRIBUTE12 , DCP.DCP_ATTRIBUTE13 , DCP.DCP_ATTRIBUTE14 , DCP.DCP_ATTRIBUTE15 , DCP.DCP_ATTRIBUTE16 , DCP.DCP_ATTRIBUTE17 , DCP.DCP_ATTRIBUTE18 , DCP.DCP_ATTRIBUTE19 , DCP.DCP_ATTRIBUTE20 , DCP.DCP_ATTRIBUTE21 , DCP.DCP_ATTRIBUTE22 , DCP.DCP_ATTRIBUTE23 , DCP.DCP_ATTRIBUTE24 , DCP.DCP_ATTRIBUTE25 , DCP.DCP_ATTRIBUTE26 , DCP.DCP_ATTRIBUTE27 , DCP.DCP_ATTRIBUTE28 , DCP.DCP_ATTRIBUTE29 , DCP.DCP_ATTRIBUTE30 , DCP.LAST_UPDATE_DATE , DCP.LAST_UPDATED_BY , DCP.LAST_UPDATE_LOGIN , DCP.CREATED_BY , DCP.CREATION_DATE , DCP.OBJECT_VERSION_NUMBER from BEN_DPNT_CVRD_PLIP_RT_F DCP WHERE DCP.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and DCP.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT DCP.ROWID ROW_ID
, DCP.DPNT_CVRD_PLIP_RT_ID
, DCP.EFFECTIVE_START_DATE
, DCP.EFFECTIVE_END_DATE
, DCP.ORDR_NUM
, DCP.EXCLD_FLAG
, DCP.ENRL_DET_DT_CD
, DCP.BUSINESS_GROUP_ID
, DCP.VRBL_RT_PRFL_ID
, DCP.PLIP_ID
, DCP.DCP_ATTRIBUTE_CATEGORY
, DCP.DCP_ATTRIBUTE1
, DCP.DCP_ATTRIBUTE2
, DCP.DCP_ATTRIBUTE3
, DCP.DCP_ATTRIBUTE4
, DCP.DCP_ATTRIBUTE5
, DCP.DCP_ATTRIBUTE6
, DCP.DCP_ATTRIBUTE7
, DCP.DCP_ATTRIBUTE8
, DCP.DCP_ATTRIBUTE9
, DCP.DCP_ATTRIBUTE10
, DCP.DCP_ATTRIBUTE11
, DCP.DCP_ATTRIBUTE12
, DCP.DCP_ATTRIBUTE13
, DCP.DCP_ATTRIBUTE14
, DCP.DCP_ATTRIBUTE15
, DCP.DCP_ATTRIBUTE16
, DCP.DCP_ATTRIBUTE17
, DCP.DCP_ATTRIBUTE18
, DCP.DCP_ATTRIBUTE19
, DCP.DCP_ATTRIBUTE20
, DCP.DCP_ATTRIBUTE21
, DCP.DCP_ATTRIBUTE22
, DCP.DCP_ATTRIBUTE23
, DCP.DCP_ATTRIBUTE24
, DCP.DCP_ATTRIBUTE25
, DCP.DCP_ATTRIBUTE26
, DCP.DCP_ATTRIBUTE27
, DCP.DCP_ATTRIBUTE28
, DCP.DCP_ATTRIBUTE29
, DCP.DCP_ATTRIBUTE30
, DCP.LAST_UPDATE_DATE
, DCP.LAST_UPDATED_BY
, DCP.LAST_UPDATE_LOGIN
, DCP.CREATED_BY
, DCP.CREATION_DATE
, DCP.OBJECT_VERSION_NUMBER
FROM BEN_DPNT_CVRD_PLIP_RT_F DCP
WHERE DCP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND DCP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))