VIEW: APPS.BEN_PRTT_RATE_CTFN_INFO_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')