View: BEN_DPNT_CVRD_OTHR_PGM_RT_V

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

View Text

SELECT DOP.ROWID ROW_ID
, DOP.DPNT_CVRD_OTHR_PGM_RT_ID
, DOP.EFFECTIVE_START_DATE
, DOP.EFFECTIVE_END_DATE
, DOP.ORDR_NUM
, DOP.EXCLD_FLAG
, DOP.ONLY_PLS_SUBJ_COBRA_FLAG
, DOP.ENRL_DET_DT_CD
, DOP.BUSINESS_GROUP_ID
, DOP.VRBL_RT_PRFL_ID
, DOP.PGM_ID
, DOP.DOP_ATTRIBUTE_CATEGORY
, DOP.DOP_ATTRIBUTE1
, DOP.DOP_ATTRIBUTE2
, DOP.DOP_ATTRIBUTE3
, DOP.DOP_ATTRIBUTE4
, DOP.DOP_ATTRIBUTE5
, DOP.DOP_ATTRIBUTE6
, DOP.DOP_ATTRIBUTE7
, DOP.DOP_ATTRIBUTE8
, DOP.DOP_ATTRIBUTE9
, DOP.DOP_ATTRIBUTE10
, DOP.DOP_ATTRIBUTE11
, DOP.DOP_ATTRIBUTE12
, DOP.DOP_ATTRIBUTE13
, DOP.DOP_ATTRIBUTE14
, DOP.DOP_ATTRIBUTE15
, DOP.DOP_ATTRIBUTE16
, DOP.DOP_ATTRIBUTE17
, DOP.DOP_ATTRIBUTE18
, DOP.DOP_ATTRIBUTE19
, DOP.DOP_ATTRIBUTE20
, DOP.DOP_ATTRIBUTE21
, DOP.DOP_ATTRIBUTE22
, DOP.DOP_ATTRIBUTE23
, DOP.DOP_ATTRIBUTE24
, DOP.DOP_ATTRIBUTE25
, DOP.DOP_ATTRIBUTE26
, DOP.DOP_ATTRIBUTE27
, DOP.DOP_ATTRIBUTE28
, DOP.DOP_ATTRIBUTE29
, DOP.DOP_ATTRIBUTE30
, DOP.LAST_UPDATE_DATE
, DOP.LAST_UPDATED_BY
, DOP.LAST_UPDATE_LOGIN
, DOP.CREATED_BY
, DOP.CREATION_DATE
, DOP.OBJECT_VERSION_NUMBER
FROM BEN_DPNT_CVRD_OTHR_PGM_RT_F DOP
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN DOP.EFFECTIVE_START_DATE
AND DOP.EFFECTIVE_END_DATE

Columns