View: BEN_PRTT_RATE_CTFN_INFO_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_PRTT_RATE_CTFN_INFO_V

View Text

SELECT PEN.PERSON_ID
, PEN.PL_ID
, PEN.OIPL_ID
, RVC.PRTT_RT_VAL_CTFN_PRVDD_ID
, RVC.PRTT_RT_VAL_ID
, PRV.ACTY_BASE_RT_ID
, PRV.RT_VAL
, PRV.RT_STRT_DT
, PRV.RT_END_DT
, RVC.ENRT_CTFN_TYP_CD
, RVC.ENRT_CTFN_RECD_DT
, RVC.ENRT_CTFN_DND_DT
, RVC.BUSINESS_GROUP_ID
, RVC.RVC_ATTRIBUTE_CATEGORY
, RVC.RVC_ATTRIBUTE1
, RVC.RVC_ATTRIBUTE2
, RVC.RVC_ATTRIBUTE3
, RVC.RVC_ATTRIBUTE4
, RVC.RVC_ATTRIBUTE5
, RVC.RVC_ATTRIBUTE6
, RVC.RVC_ATTRIBUTE7
, RVC.RVC_ATTRIBUTE8
, RVC.RVC_ATTRIBUTE9
, RVC.RVC_ATTRIBUTE10
, RVC.RVC_ATTRIBUTE11
, RVC.RVC_ATTRIBUTE12
, RVC.RVC_ATTRIBUTE13
, RVC.RVC_ATTRIBUTE14
, RVC.RVC_ATTRIBUTE15
, RVC.RVC_ATTRIBUTE16
, RVC.RVC_ATTRIBUTE17
, RVC.RVC_ATTRIBUTE18
, RVC.RVC_ATTRIBUTE19
, RVC.RVC_ATTRIBUTE20
, RVC.RVC_ATTRIBUTE21
, RVC.RVC_ATTRIBUTE22
, RVC.RVC_ATTRIBUTE23
, RVC.RVC_ATTRIBUTE24
, RVC.RVC_ATTRIBUTE25
, RVC.RVC_ATTRIBUTE26
, RVC.RVC_ATTRIBUTE27
, RVC.RVC_ATTRIBUTE28
, RVC.RVC_ATTRIBUTE29
, RVC.RVC_ATTRIBUTE30
, RVC.LAST_UPDATE_DATE
, RVC.LAST_UPDATED_BY
, RVC.LAST_UPDATE_LOGIN
, RVC.CREATED_BY
, RVC.CREATION_DATE
, RVC.REQUEST_ID
, RVC.PROGRAM_APPLICATION_ID
, RVC.PROGRAM_ID
, RVC.PROGRAM_UPDATE_DATE
, RVC.OBJECT_VERSION_NUMBER
FROM BEN_PRTT_ENRT_RSLT_F PEN
, BEN_PRTT_RT_VAL PRV
, BEN_PRTT_RT_VAL_CTFN_PRVDD RVC
, BEN_PER_IN_LER PIL
, FND_SESSIONS SE
WHERE PEN.PRTT_ENRT_RSLT_ID = PRV.PRTT_ENRT_RSLT_ID
AND PRV.PRTT_RT_VAL_ID = RVC.PRTT_RT_VAL_ID
AND PEN.PRTT_ENRT_RSLT_STAT_CD IS NULL
AND SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PEN.EFFECTIVE_START_DATE
AND PEN.EFFECTIVE_END_DATE
AND PIL.PER_IN_LER_ID=PEN.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID=PEN.BUSINESS_GROUP_ID
AND PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT')

Columns