Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_POPL_RPTG_GRP_V |
SELECT RGR.ROWID ROW_ID
, RGR.POPL_RPTG_GRP_ID
, RGR.EFFECTIVE_START_DATE
, RGR.EFFECTIVE_END_DATE
, RGR.BUSINESS_GROUP_ID
, RGR.RPTG_GRP_ID
, RGR.PGM_ID
, RGR.PL_ID
, RGR.ORDR_NUM
, RGR.RGR_ATTRIBUTE_CATEGORY
, RGR.RGR_ATTRIBUTE1
, RGR.RGR_ATTRIBUTE2
, RGR.RGR_ATTRIBUTE3
, RGR.RGR_ATTRIBUTE4
, RGR.RGR_ATTRIBUTE5
, RGR.RGR_ATTRIBUTE6
, RGR.RGR_ATTRIBUTE7
, RGR.RGR_ATTRIBUTE8
, RGR.RGR_ATTRIBUTE9
, RGR.RGR_ATTRIBUTE10
, RGR.RGR_ATTRIBUTE11
, RGR.RGR_ATTRIBUTE12
, RGR.RGR_ATTRIBUTE13
, RGR.RGR_ATTRIBUTE14
, RGR.RGR_ATTRIBUTE15
, RGR.RGR_ATTRIBUTE16
, RGR.RGR_ATTRIBUTE17
, RGR.RGR_ATTRIBUTE18
, RGR.RGR_ATTRIBUTE19
, RGR.RGR_ATTRIBUTE20
, RGR.RGR_ATTRIBUTE21
, RGR.RGR_ATTRIBUTE22
, RGR.RGR_ATTRIBUTE23
, RGR.RGR_ATTRIBUTE24
, RGR.RGR_ATTRIBUTE25
, RGR.RGR_ATTRIBUTE26
, RGR.RGR_ATTRIBUTE27
, RGR.RGR_ATTRIBUTE28
, RGR.RGR_ATTRIBUTE29
, RGR.RGR_ATTRIBUTE30
, RGR.LAST_UPDATE_DATE
, RGR.LAST_UPDATED_BY
, RGR.LAST_UPDATE_LOGIN
, RGR.CREATED_BY
, RGR.CREATION_DATE
, RGR.OBJECT_VERSION_NUMBER
FROM BEN_POPL_RPTG_GRP_F RGR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN RGR.EFFECTIVE_START_DATE
AND RGR.EFFECTIVE_END_DATE