Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PER_INFO_CHG_CS_LER_X |
SELECT PSL.PER_INFO_CHG_CS_LER_ID
, PSL.EFFECTIVE_START_DATE
, PSL.EFFECTIVE_END_DATE
, PSL.PER_INFO_CHG_CS_LER_RL
, PSL.NAME
, PSL.WHATIF_LBL_TXT
, PSL.OLD_VAL
, PSL.NEW_VAL
, PSL.SOURCE_COLUMN
, PSL.SOURCE_TABLE
, PSL.BUSINESS_GROUP_ID
, PSL.PSL_ATTRIBUTE_CATEGORY
, PSL.PSL_ATTRIBUTE1
, PSL.PSL_ATTRIBUTE2
, PSL.PSL_ATTRIBUTE3
, PSL.PSL_ATTRIBUTE4
, PSL.PSL_ATTRIBUTE5
, PSL.PSL_ATTRIBUTE6
, PSL.PSL_ATTRIBUTE7
, PSL.PSL_ATTRIBUTE8
, PSL.PSL_ATTRIBUTE9
, PSL.PSL_ATTRIBUTE10
, PSL.PSL_ATTRIBUTE11
, PSL.PSL_ATTRIBUTE12
, PSL.PSL_ATTRIBUTE13
, PSL.PSL_ATTRIBUTE14
, PSL.PSL_ATTRIBUTE15
, PSL.PSL_ATTRIBUTE16
, PSL.PSL_ATTRIBUTE17
, PSL.PSL_ATTRIBUTE18
, PSL.PSL_ATTRIBUTE19
, PSL.PSL_ATTRIBUTE20
, PSL.PSL_ATTRIBUTE21
, PSL.PSL_ATTRIBUTE22
, PSL.PSL_ATTRIBUTE23
, PSL.PSL_ATTRIBUTE24
, PSL.PSL_ATTRIBUTE25
, PSL.PSL_ATTRIBUTE26
, PSL.PSL_ATTRIBUTE27
, PSL.PSL_ATTRIBUTE28
, PSL.PSL_ATTRIBUTE29
, PSL.PSL_ATTRIBUTE30
, PSL.LAST_UPDATE_DATE
, PSL.LAST_UPDATED_BY
, PSL.LAST_UPDATE_LOGIN
, PSL.CREATED_BY
, PSL.CREATION_DATE
, PSL.OBJECT_VERSION_NUMBER
, PSL.RULE_OVERRIDES_FLAG
FROM BEN_PER_INFO_CHG_CS_LER_F PSL
WHERE TRUNC(SYSDATE) BETWEEN PSL.EFFECTIVE_START_DATE
AND PSL.EFFECTIVE_END_DATE