Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_LOS_RT_X |
SELECT LSR.LOS_RT_ID
, LSR.EFFECTIVE_START_DATE
, LSR.EFFECTIVE_END_DATE
, LSR.BUSINESS_GROUP_ID
, LSR.VRBL_RT_PRFL_ID
, LSR.LOS_FCTR_ID
, LSR.ORDR_NUM
, LSR.EXCLD_FLAG
, LSR.LSR_ATTRIBUTE_CATEGORY
, LSR.LSR_ATTRIBUTE1
, LSR.LSR_ATTRIBUTE2
, LSR.LSR_ATTRIBUTE3
, LSR.LSR_ATTRIBUTE4
, LSR.LSR_ATTRIBUTE5
, LSR.LSR_ATTRIBUTE6
, LSR.LSR_ATTRIBUTE7
, LSR.LSR_ATTRIBUTE8
, LSR.LSR_ATTRIBUTE9
, LSR.LSR_ATTRIBUTE10
, LSR.LSR_ATTRIBUTE11
, LSR.LSR_ATTRIBUTE12
, LSR.LSR_ATTRIBUTE13
, LSR.LSR_ATTRIBUTE14
, LSR.LSR_ATTRIBUTE15
, LSR.LSR_ATTRIBUTE16
, LSR.LSR_ATTRIBUTE17
, LSR.LSR_ATTRIBUTE18
, LSR.LSR_ATTRIBUTE19
, LSR.LSR_ATTRIBUTE20
, LSR.LSR_ATTRIBUTE21
, LSR.LSR_ATTRIBUTE22
, LSR.LSR_ATTRIBUTE23
, LSR.LSR_ATTRIBUTE24
, LSR.LSR_ATTRIBUTE25
, LSR.LSR_ATTRIBUTE26
, LSR.LSR_ATTRIBUTE27
, LSR.LSR_ATTRIBUTE28
, LSR.LSR_ATTRIBUTE29
, LSR.LSR_ATTRIBUTE30
, LSR.LAST_UPDATE_DATE
, LSR.LAST_UPDATED_BY
, LSR.LAST_UPDATE_LOGIN
, LSR.CREATED_BY
, LSR.CREATION_DATE
, LSR.OBJECT_VERSION_NUMBER
FROM BEN_LOS_RT_F LSR
WHERE TRUNC(SYSDATE) BETWEEN LSR.EFFECTIVE_START_DATE
AND LSR.EFFECTIVE_END_DATE