Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_REGN_FOR_REGY_BODY_X |
SELECT RRB.REGN_FOR_REGY_BODY_ID
, RRB.EFFECTIVE_START_DATE
, RRB.EFFECTIVE_END_DATE
, RRB.REGN_ADMIN_CD
, RRB.REGN_ID
, RRB.ORGANIZATION_ID
, RRB.BUSINESS_GROUP_ID
, RRB.RRB_ATTRIBUTE_CATEGORY
, RRB.RRB_ATTRIBUTE1
, RRB.RRB_ATTRIBUTE2
, RRB.RRB_ATTRIBUTE3
, RRB.RRB_ATTRIBUTE4
, RRB.RRB_ATTRIBUTE5
, RRB.RRB_ATTRIBUTE6
, RRB.RRB_ATTRIBUTE7
, RRB.RRB_ATTRIBUTE8
, RRB.RRB_ATTRIBUTE9
, RRB.RRB_ATTRIBUTE10
, RRB.RRB_ATTRIBUTE11
, RRB.RRB_ATTRIBUTE12
, RRB.RRB_ATTRIBUTE13
, RRB.RRB_ATTRIBUTE14
, RRB.RRB_ATTRIBUTE15
, RRB.RRB_ATTRIBUTE16
, RRB.RRB_ATTRIBUTE17
, RRB.RRB_ATTRIBUTE18
, RRB.RRB_ATTRIBUTE19
, RRB.RRB_ATTRIBUTE20
, RRB.RRB_ATTRIBUTE21
, RRB.RRB_ATTRIBUTE22
, RRB.RRB_ATTRIBUTE23
, RRB.RRB_ATTRIBUTE24
, RRB.RRB_ATTRIBUTE25
, RRB.RRB_ATTRIBUTE26
, RRB.RRB_ATTRIBUTE27
, RRB.RRB_ATTRIBUTE28
, RRB.RRB_ATTRIBUTE29
, RRB.RRB_ATTRIBUTE30
, RRB.LAST_UPDATE_DATE
, RRB.LAST_UPDATED_BY
, RRB.LAST_UPDATE_LOGIN
, RRB.CREATED_BY
, RRB.CREATION_DATE
, RRB.OBJECT_VERSION_NUMBER
FROM BEN_REGN_FOR_REGY_BODY_F RRB
WHERE TRUNC(SYSDATE) BETWEEN RRB.EFFECTIVE_START_DATE
AND RRB.EFFECTIVE_END_DATE