Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_LBR_MMBR_RT_X |
SELECT LMM.LBR_MMBR_RT_ID
, LMM.EFFECTIVE_START_DATE
, LMM.EFFECTIVE_END_DATE
, LMM.VRBL_RT_PRFL_ID
, LMM.EXCLD_FLAG
, LMM.LBR_MMBR_FLAG
, LMM.ORDR_NUM
, LMM.BUSINESS_GROUP_ID
, LMM.LMM_ATTRIBUTE_CATEGORY
, LMM.LMM_ATTRIBUTE1
, LMM.LMM_ATTRIBUTE2
, LMM.LMM_ATTRIBUTE3
, LMM.LMM_ATTRIBUTE4
, LMM.LMM_ATTRIBUTE5
, LMM.LMM_ATTRIBUTE6
, LMM.LMM_ATTRIBUTE7
, LMM.LMM_ATTRIBUTE8
, LMM.LMM_ATTRIBUTE9
, LMM.LMM_ATTRIBUTE10
, LMM.LMM_ATTRIBUTE11
, LMM.LMM_ATTRIBUTE12
, LMM.LMM_ATTRIBUTE13
, LMM.LMM_ATTRIBUTE14
, LMM.LMM_ATTRIBUTE15
, LMM.LMM_ATTRIBUTE16
, LMM.LMM_ATTRIBUTE17
, LMM.LMM_ATTRIBUTE18
, LMM.LMM_ATTRIBUTE19
, LMM.LMM_ATTRIBUTE20
, LMM.LMM_ATTRIBUTE21
, LMM.LMM_ATTRIBUTE22
, LMM.LMM_ATTRIBUTE23
, LMM.LMM_ATTRIBUTE24
, LMM.LMM_ATTRIBUTE25
, LMM.LMM_ATTRIBUTE26
, LMM.LMM_ATTRIBUTE27
, LMM.LMM_ATTRIBUTE28
, LMM.LMM_ATTRIBUTE29
, LMM.LMM_ATTRIBUTE30
, LMM.LAST_UPDATE_DATE
, LMM.LAST_UPDATED_BY
, LMM.LAST_UPDATE_LOGIN
, LMM.CREATED_BY
, LMM.CREATION_DATE
, LMM.OBJECT_VERSION_NUMBER
FROM BEN_LBR_MMBR_RT_F LMM
WHERE TRUNC(SYSDATE) BETWEEN LMM.EFFECTIVE_START_DATE
AND LMM.EFFECTIVE_END_DATE