Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_CSS_RLTD_PER_PER_IN_LER_X |
SELECT CSR.CSS_RLTD_PER_PER_IN_LER_ID
, CSR.EFFECTIVE_START_DATE
, CSR.EFFECTIVE_END_DATE
, CSR.ORDR_TO_PRCS_NUM
, CSR.LER_ID
, CSR.RSLTG_LER_ID
, CSR.BUSINESS_GROUP_ID
, CSR.CSR_ATTRIBUTE_CATEGORY
, CSR.CSR_ATTRIBUTE1
, CSR.CSR_ATTRIBUTE2
, CSR.CSR_ATTRIBUTE3
, CSR.CSR_ATTRIBUTE4
, CSR.CSR_ATTRIBUTE5
, CSR.CSR_ATTRIBUTE6
, CSR.CSR_ATTRIBUTE7
, CSR.CSR_ATTRIBUTE8
, CSR.CSR_ATTRIBUTE9
, CSR.CSR_ATTRIBUTE10
, CSR.CSR_ATTRIBUTE11
, CSR.CSR_ATTRIBUTE12
, CSR.CSR_ATTRIBUTE13
, CSR.CSR_ATTRIBUTE14
, CSR.CSR_ATTRIBUTE15
, CSR.CSR_ATTRIBUTE16
, CSR.CSR_ATTRIBUTE17
, CSR.CSR_ATTRIBUTE18
, CSR.CSR_ATTRIBUTE19
, CSR.CSR_ATTRIBUTE20
, CSR.CSR_ATTRIBUTE21
, CSR.CSR_ATTRIBUTE22
, CSR.CSR_ATTRIBUTE23
, CSR.CSR_ATTRIBUTE24
, CSR.CSR_ATTRIBUTE25
, CSR.CSR_ATTRIBUTE26
, CSR.CSR_ATTRIBUTE27
, CSR.CSR_ATTRIBUTE28
, CSR.CSR_ATTRIBUTE29
, CSR.CSR_ATTRIBUTE30
, CSR.LAST_UPDATE_DATE
, CSR.LAST_UPDATED_BY
, CSR.LAST_UPDATE_LOGIN
, CSR.CREATED_BY
, CSR.CREATION_DATE
, CSR.OBJECT_VERSION_NUMBER
FROM BEN_CSS_RLTD_PER_PER_IN_LER_F CSR
WHERE TRUNC(SYSDATE) BETWEEN CSR.EFFECTIVE_START_DATE
AND CSR.EFFECTIVE_END_DATE