Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PL_BNF_CTFN_X |
SELECT PCX.PL_BNF_CTFN_ID
, PCX.EFFECTIVE_START_DATE
, PCX.EFFECTIVE_END_DATE
, PCX.PL_ID
, PCX.BNF_CTFN_TYP_CD
, PCX.LACK_CTFN_SSPND_ENRT_FLAG
, PCX.PFD_FLAG
, PCX.RQD_FLAG
, PCX.CTFN_RQD_WHEN_RL
, PCX.BNF_TYP_CD
, PCX.RLSHP_TYP_CD
, PCX.BUSINESS_GROUP_ID
, PCX.PCX_ATTRIBUTE_CATEGORY
, PCX.PCX_ATTRIBUTE1
, PCX.PCX_ATTRIBUTE2
, PCX.PCX_ATTRIBUTE3
, PCX.PCX_ATTRIBUTE4
, PCX.PCX_ATTRIBUTE5
, PCX.PCX_ATTRIBUTE6
, PCX.PCX_ATTRIBUTE7
, PCX.PCX_ATTRIBUTE8
, PCX.PCX_ATTRIBUTE9
, PCX.PCX_ATTRIBUTE10
, PCX.PCX_ATTRIBUTE11
, PCX.PCX_ATTRIBUTE12
, PCX.PCX_ATTRIBUTE13
, PCX.PCX_ATTRIBUTE14
, PCX.PCX_ATTRIBUTE15
, PCX.PCX_ATTRIBUTE16
, PCX.PCX_ATTRIBUTE17
, PCX.PCX_ATTRIBUTE18
, PCX.PCX_ATTRIBUTE19
, PCX.PCX_ATTRIBUTE20
, PCX.PCX_ATTRIBUTE21
, PCX.PCX_ATTRIBUTE22
, PCX.PCX_ATTRIBUTE23
, PCX.PCX_ATTRIBUTE24
, PCX.PCX_ATTRIBUTE25
, PCX.PCX_ATTRIBUTE26
, PCX.PCX_ATTRIBUTE27
, PCX.PCX_ATTRIBUTE28
, PCX.PCX_ATTRIBUTE29
, PCX.PCX_ATTRIBUTE30
, PCX.LAST_UPDATE_DATE
, PCX.LAST_UPDATED_BY
, PCX.LAST_UPDATE_LOGIN
, PCX.CREATED_BY
, PCX.CREATION_DATE
, PCX.OBJECT_VERSION_NUMBER
FROM BEN_PL_BNF_CTFN_F PCX
WHERE TRUNC(SYSDATE) BETWEEN PCX.EFFECTIVE_START_DATE
AND PCX.EFFECTIVE_END_DATE