View: BEN_DPNT_CVRD_PLIP_RT_X

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_DPNT_CVRD_PLIP_RT_X

View Text

SELECT 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 TRUNC(SYSDATE) BETWEEN DCP.EFFECTIVE_START_DATE
AND DCP.EFFECTIVE_END_DATE

Columns