Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_CMBN_AGE_LOS_RT_V |
SELECT CMR.ROWID ROW_ID
, CMR.CMBN_AGE_LOS_RT_ID
, CMR.EFFECTIVE_START_DATE
, CMR.EFFECTIVE_END_DATE
, CMR.VRBL_RT_PRFL_ID
, CMR.CMBN_AGE_LOS_FCTR_ID
, CMR.EXCLD_FLAG
, CMR.ORDR_NUM
, CMR.BUSINESS_GROUP_ID
, CMR.CMR_ATTRIBUTE_CATEGORY
, CMR.CMR_ATTRIBUTE1
, CMR.CMR_ATTRIBUTE2
, CMR.CMR_ATTRIBUTE3
, CMR.CMR_ATTRIBUTE4
, CMR.CMR_ATTRIBUTE5
, CMR.CMR_ATTRIBUTE6
, CMR.CMR_ATTRIBUTE7
, CMR.CMR_ATTRIBUTE8
, CMR.CMR_ATTRIBUTE9
, CMR.CMR_ATTRIBUTE10
, CMR.CMR_ATTRIBUTE11
, CMR.CMR_ATTRIBUTE12
, CMR.CMR_ATTRIBUTE13
, CMR.CMR_ATTRIBUTE14
, CMR.CMR_ATTRIBUTE15
, CMR.CMR_ATTRIBUTE16
, CMR.CMR_ATTRIBUTE17
, CMR.CMR_ATTRIBUTE18
, CMR.CMR_ATTRIBUTE19
, CMR.CMR_ATTRIBUTE20
, CMR.CMR_ATTRIBUTE21
, CMR.CMR_ATTRIBUTE22
, CMR.CMR_ATTRIBUTE23
, CMR.CMR_ATTRIBUTE24
, CMR.CMR_ATTRIBUTE25
, CMR.CMR_ATTRIBUTE26
, CMR.CMR_ATTRIBUTE27
, CMR.CMR_ATTRIBUTE28
, CMR.CMR_ATTRIBUTE29
, CMR.CMR_ATTRIBUTE30
, CMR.LAST_UPDATE_DATE
, CMR.LAST_UPDATED_BY
, CMR.LAST_UPDATE_LOGIN
, CMR.CREATED_BY
, CMR.CREATION_DATE
, CMR.OBJECT_VERSION_NUMBER
FROM BEN_CMBN_AGE_LOS_RT_F CMR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN CMR.EFFECTIVE_START_DATE
AND CMR.EFFECTIVE_END_DATE