Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_DPNT_OTHR_PTIP_RT_X |
SELECT DOT.ROWID ROW_ID
, DOT.DPNT_OTHR_PTIP_RT_ID
, DOT.EFFECTIVE_START_DATE
, DOT.EFFECTIVE_END_DATE
, DOT.EXCLD_FLAG
, DOT.ORDR_NUM
, DOT.PTIP_ID
, DOT.VRBL_RT_PRFL_ID
, DOT.BUSINESS_GROUP_ID
, DOT.DOT_ATTRIBUTE_CATEGORY
, DOT.DOT_ATTRIBUTE1
, DOT.DOT_ATTRIBUTE2
, DOT.DOT_ATTRIBUTE3
, DOT.DOT_ATTRIBUTE4
, DOT.DOT_ATTRIBUTE5
, DOT.DOT_ATTRIBUTE6
, DOT.DOT_ATTRIBUTE7
, DOT.DOT_ATTRIBUTE8
, DOT.DOT_ATTRIBUTE9
, DOT.DOT_ATTRIBUTE10
, DOT.DOT_ATTRIBUTE11
, DOT.DOT_ATTRIBUTE12
, DOT.DOT_ATTRIBUTE13
, DOT.DOT_ATTRIBUTE14
, DOT.DOT_ATTRIBUTE15
, DOT.DOT_ATTRIBUTE16
, DOT.DOT_ATTRIBUTE17
, DOT.DOT_ATTRIBUTE18
, DOT.DOT_ATTRIBUTE19
, DOT.DOT_ATTRIBUTE20
, DOT.DOT_ATTRIBUTE21
, DOT.DOT_ATTRIBUTE22
, DOT.DOT_ATTRIBUTE23
, DOT.DOT_ATTRIBUTE24
, DOT.DOT_ATTRIBUTE25
, DOT.DOT_ATTRIBUTE26
, DOT.DOT_ATTRIBUTE27
, DOT.DOT_ATTRIBUTE28
, DOT.DOT_ATTRIBUTE29
, DOT.DOT_ATTRIBUTE30
, DOT.LAST_UPDATE_DATE
, DOT.LAST_UPDATED_BY
, DOT.LAST_UPDATE_LOGIN
, DOT.CREATED_BY
, DOT.CREATION_DATE
, DOT.OBJECT_VERSION_NUMBER
FROM BEN_DPNT_OTHR_PTIP_RT_F DOT
, FND_SESSIONS SE
WHERE TRUNC(SYSDATE) BETWEEN DOT.EFFECTIVE_START_DATE
AND DOT.EFFECTIVE_END_DATE