Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PER_BNFTS_BAL_X |
SELECT PBB.PER_BNFTS_BAL_ID
, PBB.EFFECTIVE_START_DATE
, PBB.EFFECTIVE_END_DATE
, PBB.VAL
, PBB.BNFTS_BAL_ID
, PBB.PERSON_ID
, PBB.BUSINESS_GROUP_ID
, PBB.PBB_ATTRIBUTE_CATEGORY
, PBB.PBB_ATTRIBUTE1
, PBB.PBB_ATTRIBUTE2
, PBB.PBB_ATTRIBUTE3
, PBB.PBB_ATTRIBUTE4
, PBB.PBB_ATTRIBUTE5
, PBB.PBB_ATTRIBUTE6
, PBB.PBB_ATTRIBUTE7
, PBB.PBB_ATTRIBUTE8
, PBB.PBB_ATTRIBUTE9
, PBB.PBB_ATTRIBUTE10
, PBB.PBB_ATTRIBUTE11
, PBB.PBB_ATTRIBUTE12
, PBB.PBB_ATTRIBUTE13
, PBB.PBB_ATTRIBUTE14
, PBB.PBB_ATTRIBUTE15
, PBB.PBB_ATTRIBUTE16
, PBB.PBB_ATTRIBUTE17
, PBB.PBB_ATTRIBUTE18
, PBB.PBB_ATTRIBUTE19
, PBB.PBB_ATTRIBUTE20
, PBB.PBB_ATTRIBUTE21
, PBB.PBB_ATTRIBUTE22
, PBB.PBB_ATTRIBUTE23
, PBB.PBB_ATTRIBUTE24
, PBB.PBB_ATTRIBUTE25
, PBB.PBB_ATTRIBUTE26
, PBB.PBB_ATTRIBUTE27
, PBB.PBB_ATTRIBUTE28
, PBB.PBB_ATTRIBUTE29
, PBB.PBB_ATTRIBUTE30
, PBB.LAST_UPDATE_DATE
, PBB.LAST_UPDATED_BY
, PBB.LAST_UPDATE_LOGIN
, PBB.CREATED_BY
, PBB.CREATION_DATE
, PBB.OBJECT_VERSION_NUMBER
FROM BEN_PER_BNFTS_BAL_F PBB
WHERE TRUNC(SYSDATE) BETWEEN PBB.EFFECTIVE_START_DATE
AND PBB.EFFECTIVE_END_DATE