Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_PRBTN_PERD_PRTE_X |
SELECT ELIG_PRBTN_PERD_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, PROBATION_PERIOD
, PROBATION_UNIT
, EPN_ATTRIBUTE_CATEGORY
, EPN_ATTRIBUTE1
, EPN_ATTRIBUTE2
, EPN_ATTRIBUTE3
, EPN_ATTRIBUTE4
, EPN_ATTRIBUTE5
, EPN_ATTRIBUTE6
, EPN_ATTRIBUTE7
, EPN_ATTRIBUTE8
, EPN_ATTRIBUTE9
, EPN_ATTRIBUTE10
, EPN_ATTRIBUTE11
, EPN_ATTRIBUTE12
, EPN_ATTRIBUTE13
, EPN_ATTRIBUTE14
, EPN_ATTRIBUTE15
, EPN_ATTRIBUTE16
, EPN_ATTRIBUTE17
, EPN_ATTRIBUTE18
, EPN_ATTRIBUTE19
, EPN_ATTRIBUTE20
, EPN_ATTRIBUTE21
, EPN_ATTRIBUTE22
, EPN_ATTRIBUTE23
, EPN_ATTRIBUTE24
, EPN_ATTRIBUTE25
, EPN_ATTRIBUTE26
, EPN_ATTRIBUTE27
, EPN_ATTRIBUTE28
, EPN_ATTRIBUTE29
, EPN_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_PRBTN_PERD_PRTE_F EPN
WHERE TRUNC(SYSDATE) BETWEEN EPN.EFFECTIVE_START_DATE
AND EPN.EFFECTIVE_END_DATE