Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_CVRD_DPNT_CTFN_PRVDD_X |
SELECT CCP.CVRD_DPNT_CTFN_PRVDD_ID
, CCP.EFFECTIVE_START_DATE
, CCP.EFFECTIVE_END_DATE
, CCP.DPNT_DSGN_CTFN_TYP_CD
, CCP.DPNT_DSGN_CTFN_RQD_FLAG
, CCP.DPNT_DSGN_CTFN_RECD_DT
, CCP.ELIG_CVRD_DPNT_ID
, CCP.PRTT_ENRT_ACTN_ID
, CCP.BUSINESS_GROUP_ID
, CCP.CCP_ATTRIBUTE_CATEGORY
, CCP.CCP_ATTRIBUTE1
, CCP.CCP_ATTRIBUTE2
, CCP.CCP_ATTRIBUTE3
, CCP.CCP_ATTRIBUTE4
, CCP.CCP_ATTRIBUTE5
, CCP.CCP_ATTRIBUTE6
, CCP.CCP_ATTRIBUTE7
, CCP.CCP_ATTRIBUTE8
, CCP.CCP_ATTRIBUTE9
, CCP.CCP_ATTRIBUTE10
, CCP.CCP_ATTRIBUTE11
, CCP.CCP_ATTRIBUTE12
, CCP.CCP_ATTRIBUTE13
, CCP.CCP_ATTRIBUTE14
, CCP.CCP_ATTRIBUTE15
, CCP.CCP_ATTRIBUTE16
, CCP.CCP_ATTRIBUTE17
, CCP.CCP_ATTRIBUTE18
, CCP.CCP_ATTRIBUTE19
, CCP.CCP_ATTRIBUTE20
, CCP.CCP_ATTRIBUTE21
, CCP.CCP_ATTRIBUTE22
, CCP.CCP_ATTRIBUTE23
, CCP.CCP_ATTRIBUTE24
, CCP.CCP_ATTRIBUTE25
, CCP.CCP_ATTRIBUTE26
, CCP.CCP_ATTRIBUTE27
, CCP.CCP_ATTRIBUTE28
, CCP.CCP_ATTRIBUTE29
, CCP.CCP_ATTRIBUTE30
, CCP.LAST_UPDATE_DATE
, CCP.LAST_UPDATED_BY
, CCP.LAST_UPDATE_LOGIN
, CCP.CREATED_BY
, CCP.CREATION_DATE
, CCP.REQUEST_ID
, CCP.PROGRAM_APPLICATION_ID
, CCP.PROGRAM_ID
, CCP.PROGRAM_UPDATE_DATE
, CCP.OBJECT_VERSION_NUMBER
FROM BEN_CVRD_DPNT_CTFN_PRVDD_F CCP
WHERE TRUNC(SYSDATE) BETWEEN CCP.EFFECTIVE_START_DATE
AND CCP.EFFECTIVE_END_DATE