Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PPL_GRP_RT_X |
SELECT PGR.PPL_GRP_RT_ID
, PGR.EFFECTIVE_START_DATE
, PGR.EFFECTIVE_END_DATE
, PGR.ORDR_NUM
, PGR.EXCLD_FLAG
, PGR.VRBL_RT_PRFL_ID
, PGR.PEOPLE_GROUP_ID
, PGR.BUSINESS_GROUP_ID
, PGR.PGR_ATTRIBUTE_CATEGORY
, PGR.PGR_ATTRIBUTE1
, PGR.PGR_ATTRIBUTE2
, PGR.PGR_ATTRIBUTE3
, PGR.PGR_ATTRIBUTE4
, PGR.PGR_ATTRIBUTE5
, PGR.PGR_ATTRIBUTE6
, PGR.PGR_ATTRIBUTE7
, PGR.PGR_ATTRIBUTE8
, PGR.PGR_ATTRIBUTE9
, PGR.PGR_ATTRIBUTE10
, PGR.PGR_ATTRIBUTE11
, PGR.PGR_ATTRIBUTE12
, PGR.PGR_ATTRIBUTE13
, PGR.PGR_ATTRIBUTE14
, PGR.PGR_ATTRIBUTE15
, PGR.PGR_ATTRIBUTE16
, PGR.PGR_ATTRIBUTE17
, PGR.PGR_ATTRIBUTE18
, PGR.PGR_ATTRIBUTE19
, PGR.PGR_ATTRIBUTE20
, PGR.PGR_ATTRIBUTE21
, PGR.PGR_ATTRIBUTE22
, PGR.PGR_ATTRIBUTE23
, PGR.PGR_ATTRIBUTE24
, PGR.PGR_ATTRIBUTE25
, PGR.PGR_ATTRIBUTE26
, PGR.PGR_ATTRIBUTE27
, PGR.PGR_ATTRIBUTE28
, PGR.PGR_ATTRIBUTE29
, PGR.PGR_ATTRIBUTE30
, PGR.LAST_UPDATE_DATE
, PGR.LAST_UPDATED_BY
, PGR.LAST_UPDATE_LOGIN
, PGR.CREATED_BY
, PGR.CREATION_DATE
, PGR.OBJECT_VERSION_NUMBER
FROM BEN_PPL_GRP_RT_F PGR
WHERE TRUNC(SYSDATE) BETWEEN PGR.EFFECTIVE_START_DATE
AND PGR.EFFECTIVE_END_DATE