VIEW: APPS.BEN_DPNT_CVRD_OTHR_PL_RT

Source

View Text - Preformatted

SELECT DCL.ROWID ROW_ID, DCL.DPNT_CVRD_OTHR_PL_RT_ID , DCL.EFFECTIVE_START_DATE , DCL.EFFECTIVE_END_DATE , DCL.ORDR_NUM , DCL.EXCLD_FLAG , DCL.CVG_DET_DT_CD , DCL.BUSINESS_GROUP_ID , DCL.VRBL_RT_PRFL_ID , DCL.PL_ID , DCL.DCL_ATTRIBUTE_CATEGORY , DCL.DCL_ATTRIBUTE1 , DCL.DCL_ATTRIBUTE2 , DCL.DCL_ATTRIBUTE3 , DCL.DCL_ATTRIBUTE4 , DCL.DCL_ATTRIBUTE5 , DCL.DCL_ATTRIBUTE6 , DCL.DCL_ATTRIBUTE7 , DCL.DCL_ATTRIBUTE8 , DCL.DCL_ATTRIBUTE9 , DCL.DCL_ATTRIBUTE10 , DCL.DCL_ATTRIBUTE11 , DCL.DCL_ATTRIBUTE12 , DCL.DCL_ATTRIBUTE13 , DCL.DCL_ATTRIBUTE14 , DCL.DCL_ATTRIBUTE15 , DCL.DCL_ATTRIBUTE16 , DCL.DCL_ATTRIBUTE17 , DCL.DCL_ATTRIBUTE18 , DCL.DCL_ATTRIBUTE19 , DCL.DCL_ATTRIBUTE20 , DCL.DCL_ATTRIBUTE21 , DCL.DCL_ATTRIBUTE22 , DCL.DCL_ATTRIBUTE23 , DCL.DCL_ATTRIBUTE24 , DCL.DCL_ATTRIBUTE25 , DCL.DCL_ATTRIBUTE26 , DCL.DCL_ATTRIBUTE27 , DCL.DCL_ATTRIBUTE28 , DCL.DCL_ATTRIBUTE29 , DCL.DCL_ATTRIBUTE30 , DCL.LAST_UPDATE_DATE , DCL.LAST_UPDATED_BY , DCL.LAST_UPDATE_LOGIN , DCL.CREATED_BY , DCL.CREATION_DATE , DCL.OBJECT_VERSION_NUMBER from BEN_DPNT_CVRD_OTHR_PL_RT_F DCL WHERE DCL.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and DCL.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT DCL.ROWID ROW_ID
, DCL.DPNT_CVRD_OTHR_PL_RT_ID
, DCL.EFFECTIVE_START_DATE
, DCL.EFFECTIVE_END_DATE
, DCL.ORDR_NUM
, DCL.EXCLD_FLAG
, DCL.CVG_DET_DT_CD
, DCL.BUSINESS_GROUP_ID
, DCL.VRBL_RT_PRFL_ID
, DCL.PL_ID
, DCL.DCL_ATTRIBUTE_CATEGORY
, DCL.DCL_ATTRIBUTE1
, DCL.DCL_ATTRIBUTE2
, DCL.DCL_ATTRIBUTE3
, DCL.DCL_ATTRIBUTE4
, DCL.DCL_ATTRIBUTE5
, DCL.DCL_ATTRIBUTE6
, DCL.DCL_ATTRIBUTE7
, DCL.DCL_ATTRIBUTE8
, DCL.DCL_ATTRIBUTE9
, DCL.DCL_ATTRIBUTE10
, DCL.DCL_ATTRIBUTE11
, DCL.DCL_ATTRIBUTE12
, DCL.DCL_ATTRIBUTE13
, DCL.DCL_ATTRIBUTE14
, DCL.DCL_ATTRIBUTE15
, DCL.DCL_ATTRIBUTE16
, DCL.DCL_ATTRIBUTE17
, DCL.DCL_ATTRIBUTE18
, DCL.DCL_ATTRIBUTE19
, DCL.DCL_ATTRIBUTE20
, DCL.DCL_ATTRIBUTE21
, DCL.DCL_ATTRIBUTE22
, DCL.DCL_ATTRIBUTE23
, DCL.DCL_ATTRIBUTE24
, DCL.DCL_ATTRIBUTE25
, DCL.DCL_ATTRIBUTE26
, DCL.DCL_ATTRIBUTE27
, DCL.DCL_ATTRIBUTE28
, DCL.DCL_ATTRIBUTE29
, DCL.DCL_ATTRIBUTE30
, DCL.LAST_UPDATE_DATE
, DCL.LAST_UPDATED_BY
, DCL.LAST_UPDATE_LOGIN
, DCL.CREATED_BY
, DCL.CREATION_DATE
, DCL.OBJECT_VERSION_NUMBER
FROM BEN_DPNT_CVRD_OTHR_PL_RT_F DCL
WHERE DCL.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND DCL.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))