Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_RLTD_PER_CHG_CS_LER_V |
SELECT RCL.ROWID ROW_ID
, RCL.RLTD_PER_CHG_CS_LER_ID
, RCL.EFFECTIVE_START_DATE
, RCL.EFFECTIVE_END_DATE
, RCL.NAME
, RCL.WHATIF_LBL_TXT
, RCL.OLD_VAL
, RCL.NEW_VAL
, RCL.SOURCE_COLUMN
, RCL.SOURCE_TABLE
, RCL.RLTD_PER_CHG_CS_LER_RL
, RCL.BUSINESS_GROUP_ID
, RCL.RCL_ATTRIBUTE_CATEGORY
, RCL.RCL_ATTRIBUTE1
, RCL.RCL_ATTRIBUTE2
, RCL.RCL_ATTRIBUTE3
, RCL.RCL_ATTRIBUTE4
, RCL.RCL_ATTRIBUTE5
, RCL.RCL_ATTRIBUTE6
, RCL.RCL_ATTRIBUTE7
, RCL.RCL_ATTRIBUTE8
, RCL.RCL_ATTRIBUTE9
, RCL.RCL_ATTRIBUTE10
, RCL.RCL_ATTRIBUTE11
, RCL.RCL_ATTRIBUTE12
, RCL.RCL_ATTRIBUTE13
, RCL.RCL_ATTRIBUTE14
, RCL.RCL_ATTRIBUTE15
, RCL.RCL_ATTRIBUTE16
, RCL.RCL_ATTRIBUTE17
, RCL.RCL_ATTRIBUTE18
, RCL.RCL_ATTRIBUTE19
, RCL.RCL_ATTRIBUTE20
, RCL.RCL_ATTRIBUTE21
, RCL.RCL_ATTRIBUTE22
, RCL.RCL_ATTRIBUTE23
, RCL.RCL_ATTRIBUTE24
, RCL.RCL_ATTRIBUTE25
, RCL.RCL_ATTRIBUTE26
, RCL.RCL_ATTRIBUTE27
, RCL.RCL_ATTRIBUTE28
, RCL.RCL_ATTRIBUTE29
, RCL.RCL_ATTRIBUTE30
, RCL.LAST_UPDATE_DATE
, RCL.LAST_UPDATED_BY
, RCL.LAST_UPDATE_LOGIN
, RCL.CREATED_BY
, RCL.CREATION_DATE
, RCL.OBJECT_VERSION_NUMBER
, RCL.RULE_OVERRIDES_FLAG
FROM BEN_RLTD_PER_CHG_CS_LER_F RCL
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN RCL.EFFECTIVE_START_DATE
AND RCL.EFFECTIVE_END_DATE