Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PL_DPNT_CVG_CTFN_X |
SELECT PND.PL_DPNT_CVG_CTFN_ID
, PND.EFFECTIVE_START_DATE
, PND.EFFECTIVE_END_DATE
, PND.PL_ID
, PND.PFD_FLAG
, PND.CTFN_RQD_WHEN_RL
, PND.LACK_CTFN_SSPND_ENRT_FLAG
, PND.DPNT_CVG_CTFN_TYP_CD
, PND.RQD_FLAG
, PND.RLSHP_TYP_CD
, PND.BUSINESS_GROUP_ID
, PND.PND_ATTRIBUTE_CATEGORY
, PND.PND_ATTRIBUTE1
, PND.PND_ATTRIBUTE2
, PND.PND_ATTRIBUTE3
, PND.PND_ATTRIBUTE4
, PND.PND_ATTRIBUTE5
, PND.PND_ATTRIBUTE6
, PND.PND_ATTRIBUTE7
, PND.PND_ATTRIBUTE8
, PND.PND_ATTRIBUTE9
, PND.PND_ATTRIBUTE10
, PND.PND_ATTRIBUTE11
, PND.PND_ATTRIBUTE12
, PND.PND_ATTRIBUTE13
, PND.PND_ATTRIBUTE14
, PND.PND_ATTRIBUTE15
, PND.PND_ATTRIBUTE16
, PND.PND_ATTRIBUTE17
, PND.PND_ATTRIBUTE18
, PND.PND_ATTRIBUTE19
, PND.PND_ATTRIBUTE20
, PND.PND_ATTRIBUTE21
, PND.PND_ATTRIBUTE22
, PND.PND_ATTRIBUTE23
, PND.PND_ATTRIBUTE24
, PND.PND_ATTRIBUTE25
, PND.PND_ATTRIBUTE26
, PND.PND_ATTRIBUTE27
, PND.PND_ATTRIBUTE28
, PND.PND_ATTRIBUTE29
, PND.PND_ATTRIBUTE30
, PND.LAST_UPDATE_DATE
, PND.LAST_UPDATED_BY
, PND.LAST_UPDATE_LOGIN
, PND.CREATED_BY
, PND.CREATION_DATE
, PND.REQUEST_ID
, PND.PROGRAM_APPLICATION_ID
, PND.PROGRAM_ID
, PND.PROGRAM_UPDATE_DATE
, PND.OBJECT_VERSION_NUMBER
FROM BEN_PL_DPNT_CVG_CTFN_F PND
WHERE TRUNC(SYSDATE) BETWEEN PND.EFFECTIVE_START_DATE
AND PND.EFFECTIVE_END_DATE