Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_REGN_X |
SELECT REG.REGN_ID
, REG.EFFECTIVE_START_DATE
, REG.EFFECTIVE_END_DATE
, REG.NAME
, REG.STTRY_CITN_NAME
, REG.ORGANIZATION_ID
, REG.BUSINESS_GROUP_ID
, REG.REG_ATTRIBUTE_CATEGORY
, REG.REG_ATTRIBUTE1
, REG.REG_ATTRIBUTE2
, REG.REG_ATTRIBUTE3
, REG.REG_ATTRIBUTE4
, REG.REG_ATTRIBUTE5
, REG.REG_ATTRIBUTE6
, REG.REG_ATTRIBUTE7
, REG.REG_ATTRIBUTE8
, REG.REG_ATTRIBUTE9
, REG.REG_ATTRIBUTE10
, REG.REG_ATTRIBUTE11
, REG.REG_ATTRIBUTE12
, REG.REG_ATTRIBUTE13
, REG.REG_ATTRIBUTE14
, REG.REG_ATTRIBUTE15
, REG.REG_ATTRIBUTE16
, REG.REG_ATTRIBUTE17
, REG.REG_ATTRIBUTE18
, REG.REG_ATTRIBUTE19
, REG.REG_ATTRIBUTE20
, REG.REG_ATTRIBUTE21
, REG.REG_ATTRIBUTE22
, REG.REG_ATTRIBUTE23
, REG.REG_ATTRIBUTE24
, REG.REG_ATTRIBUTE25
, REG.REG_ATTRIBUTE26
, REG.REG_ATTRIBUTE27
, REG.REG_ATTRIBUTE28
, REG.REG_ATTRIBUTE29
, REG.REG_ATTRIBUTE30
, REG.LAST_UPDATE_DATE
, REG.LAST_UPDATED_BY
, REG.LAST_UPDATE_LOGIN
, REG.CREATED_BY
, REG.CREATION_DATE
, REG.OBJECT_VERSION_NUMBER
FROM BEN_REGN_F REG
WHERE TRUNC(SYSDATE) BETWEEN REG.EFFECTIVE_START_DATE
AND REG.EFFECTIVE_END_DATE