VIEW: APPS.BEN_DPNT_CVRD_ANTHR_PL_CVG_V

Source

View Text - Preformatted

SELECT dpc.ROWID ROW_ID, dpc.DPNT_CVRD_ANTHR_PL_CVG_ID ,dpc.EFFECTIVE_START_DATE ,dpc.EFFECTIVE_END_DATE ,dpc.BUSINESS_GROUP_ID ,dpc.CVG_DET_DT_CD ,dpc.ORDR_NUM ,dpc.EXCLD_FLAG ,dpc.DPNT_CVG_ELIGY_PRFL_ID ,dpc.PL_ID ,dpc.DPC_ATTRIBUTE_CATEGORY ,dpc.DPC_ATTRIBUTE1 ,dpc.DPC_ATTRIBUTE2 ,dpc.DPC_ATTRIBUTE3 ,dpc.DPC_ATTRIBUTE4 ,dpc.DPC_ATTRIBUTE5 ,dpc.DPC_ATTRIBUTE6 ,dpc.DPC_ATTRIBUTE7 ,dpc.DPC_ATTRIBUTE8 ,dpc.DPC_ATTRIBUTE9 ,dpc.DPC_ATTRIBUTE10 ,dpc.DPC_ATTRIBUTE11 ,dpc.DPC_ATTRIBUTE12 ,dpc.DPC_ATTRIBUTE13 ,dpc.DPC_ATTRIBUTE14 ,dpc.DPC_ATTRIBUTE15 ,dpc.DPC_ATTRIBUTE16 ,dpc.DPC_ATTRIBUTE17 ,dpc.DPC_ATTRIBUTE18 ,dpc.DPC_ATTRIBUTE19 ,dpc.DPC_ATTRIBUTE20 ,dpc.DPC_ATTRIBUTE21 ,dpc.DPC_ATTRIBUTE22 ,dpc.DPC_ATTRIBUTE23 ,dpc.DPC_ATTRIBUTE24 ,dpc.DPC_ATTRIBUTE25 ,dpc.DPC_ATTRIBUTE26 ,dpc.DPC_ATTRIBUTE27 ,dpc.DPC_ATTRIBUTE28 ,dpc.DPC_ATTRIBUTE29 ,dpc.DPC_ATTRIBUTE30 ,dpc.LAST_UPDATE_DATE ,dpc.LAST_UPDATED_BY ,dpc.LAST_UPDATE_LOGIN ,dpc.CREATED_BY ,dpc.CREATION_DATE ,dpc.OBJECT_VERSION_NUMBER from BEN_DPNT_CVRD_ANTHR_PL_CVG_F dpc, fnd_sessions se WHERE se.session_id = userenv('sessionid') and se.effective_date between dpc.effective_start_date and dpc.effective_end_date

View Text - HTML Formatted

SELECT DPC.ROWID ROW_ID
, DPC.DPNT_CVRD_ANTHR_PL_CVG_ID
, DPC.EFFECTIVE_START_DATE
, DPC.EFFECTIVE_END_DATE
, DPC.BUSINESS_GROUP_ID
, DPC.CVG_DET_DT_CD
, DPC.ORDR_NUM
, DPC.EXCLD_FLAG
, DPC.DPNT_CVG_ELIGY_PRFL_ID
, DPC.PL_ID
, DPC.DPC_ATTRIBUTE_CATEGORY
, DPC.DPC_ATTRIBUTE1
, DPC.DPC_ATTRIBUTE2
, DPC.DPC_ATTRIBUTE3
, DPC.DPC_ATTRIBUTE4
, DPC.DPC_ATTRIBUTE5
, DPC.DPC_ATTRIBUTE6
, DPC.DPC_ATTRIBUTE7
, DPC.DPC_ATTRIBUTE8
, DPC.DPC_ATTRIBUTE9
, DPC.DPC_ATTRIBUTE10
, DPC.DPC_ATTRIBUTE11
, DPC.DPC_ATTRIBUTE12
, DPC.DPC_ATTRIBUTE13
, DPC.DPC_ATTRIBUTE14
, DPC.DPC_ATTRIBUTE15
, DPC.DPC_ATTRIBUTE16
, DPC.DPC_ATTRIBUTE17
, DPC.DPC_ATTRIBUTE18
, DPC.DPC_ATTRIBUTE19
, DPC.DPC_ATTRIBUTE20
, DPC.DPC_ATTRIBUTE21
, DPC.DPC_ATTRIBUTE22
, DPC.DPC_ATTRIBUTE23
, DPC.DPC_ATTRIBUTE24
, DPC.DPC_ATTRIBUTE25
, DPC.DPC_ATTRIBUTE26
, DPC.DPC_ATTRIBUTE27
, DPC.DPC_ATTRIBUTE28
, DPC.DPC_ATTRIBUTE29
, DPC.DPC_ATTRIBUTE30
, DPC.LAST_UPDATE_DATE
, DPC.LAST_UPDATED_BY
, DPC.LAST_UPDATE_LOGIN
, DPC.CREATED_BY
, DPC.CREATION_DATE
, DPC.OBJECT_VERSION_NUMBER
FROM BEN_DPNT_CVRD_ANTHR_PL_CVG_F DPC
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN DPC.EFFECTIVE_START_DATE
AND DPC.EFFECTIVE_END_DATE