Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ACRS_PTIP_CVG_X |
SELECT APC.ACRS_PTIP_CVG_ID
, APC.EFFECTIVE_START_DATE
, APC.EFFECTIVE_END_DATE
, APC.NAME
, APC.MX_CVG_ALWD_AMT
, APC.MN_CVG_ALWD_AMT
, APC.BUSINESS_GROUP_ID
, APC.PGM_ID
, APC.APC_ATTRIBUTE_CATEGORY
, APC.APC_ATTRIBUTE1
, APC.APC_ATTRIBUTE2
, APC.APC_ATTRIBUTE3
, APC.APC_ATTRIBUTE4
, APC.APC_ATTRIBUTE5
, APC.APC_ATTRIBUTE6
, APC.APC_ATTRIBUTE7
, APC.APC_ATTRIBUTE8
, APC.APC_ATTRIBUTE9
, APC.APC_ATTRIBUTE10
, APC.APC_ATTRIBUTE11
, APC.APC_ATTRIBUTE12
, APC.APC_ATTRIBUTE13
, APC.APC_ATTRIBUTE14
, APC.APC_ATTRIBUTE15
, APC.APC_ATTRIBUTE16
, APC.APC_ATTRIBUTE17
, APC.APC_ATTRIBUTE18
, APC.APC_ATTRIBUTE19
, APC.APC_ATTRIBUTE20
, APC.APC_ATTRIBUTE21
, APC.APC_ATTRIBUTE22
, APC.APC_ATTRIBUTE23
, APC.APC_ATTRIBUTE24
, APC.APC_ATTRIBUTE25
, APC.APC_ATTRIBUTE26
, APC.APC_ATTRIBUTE27
, APC.APC_ATTRIBUTE28
, APC.APC_ATTRIBUTE29
, APC.APC_ATTRIBUTE30
, APC.LAST_UPDATE_DATE
, APC.LAST_UPDATED_BY
, APC.LAST_UPDATE_LOGIN
, APC.CREATED_BY
, APC.CREATION_DATE
, APC.OBJECT_VERSION_NUMBER
FROM BEN_ACRS_PTIP_CVG_F APC
WHERE TRUNC(SYSDATE) BETWEEN APC.EFFECTIVE_START_DATE
AND APC.EFFECTIVE_END_DATE