Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ACTY_BASE_RT_CTFN_X |
SELECT ABC.ACTY_BASE_RT_CTFN_ID
, ABC.EFFECTIVE_START_DATE
, ABC.EFFECTIVE_END_DATE
, ABC.ENRT_CTFN_TYP_CD
, ABC.CTFN_RQD_WHEN_RL
, ABC.RQD_FLAG
, ABC.ACTY_BASE_RT_ID
, ABC.BUSINESS_GROUP_ID
, ABC.ABC_ATTRIBUTE_CATEGORY
, ABC.ABC_ATTRIBUTE1
, ABC.ABC_ATTRIBUTE2
, ABC.ABC_ATTRIBUTE3
, ABC.ABC_ATTRIBUTE4
, ABC.ABC_ATTRIBUTE5
, ABC.ABC_ATTRIBUTE6
, ABC.ABC_ATTRIBUTE7
, ABC.ABC_ATTRIBUTE8
, ABC.ABC_ATTRIBUTE9
, ABC.ABC_ATTRIBUTE10
, ABC.ABC_ATTRIBUTE11
, ABC.ABC_ATTRIBUTE12
, ABC.ABC_ATTRIBUTE13
, ABC.ABC_ATTRIBUTE14
, ABC.ABC_ATTRIBUTE15
, ABC.ABC_ATTRIBUTE16
, ABC.ABC_ATTRIBUTE17
, ABC.ABC_ATTRIBUTE18
, ABC.ABC_ATTRIBUTE19
, ABC.ABC_ATTRIBUTE20
, ABC.ABC_ATTRIBUTE21
, ABC.ABC_ATTRIBUTE22
, ABC.ABC_ATTRIBUTE23
, ABC.ABC_ATTRIBUTE24
, ABC.ABC_ATTRIBUTE25
, ABC.ABC_ATTRIBUTE26
, ABC.ABC_ATTRIBUTE27
, ABC.ABC_ATTRIBUTE28
, ABC.ABC_ATTRIBUTE29
, ABC.ABC_ATTRIBUTE30
, ABC.LAST_UPDATE_DATE
, ABC.LAST_UPDATED_BY
, ABC.LAST_UPDATE_LOGIN
, ABC.CREATED_BY
, ABC.CREATION_DATE
, ABC.OBJECT_VERSION_NUMBER
FROM BEN_ACTY_BASE_RT_CTFN_F ABC
WHERE TRUNC(SYSDATE) BETWEEN ABC.EFFECTIVE_START_DATE
AND ABC.EFFECTIVE_END_DATE