VIEW: APPS.BEN_ENRT_BNF_PLAN_V

Source

View Text - Preformatted

SELECT pen.prtt_enrt_rslt_id, pen.pl_id, pen.oipl_id, pen.uom, pen.enrt_cvg_strt_dt, pen.effective_start_date, pen.effective_end_date, pen.business_group_id, pen.person_id, pen.enrt_cvg_thru_dt, pen.object_version_number, pen.per_in_ler_id, pen.bnft_amt from ben_prtt_enrt_rslt_f pen, ben_pl_f pl, fnd_sessions se WHERE se.effective_date between pen.effective_start_date and pen.effective_end_date and se.effective_date <= pen.enrt_cvg_thru_dt and pen.prtt_enrt_rslt_stat_cd is null and pen.pl_id = pl.pl_id and pen.business_group_id = pl.business_group_id and pl.bnf_dsgn_cd is not null and pl.pl_stat_cd = 'A' and se.effective_date between pl.effective_start_date and pl.effective_end_date and (pl.svgs_pl_flag <> 'Y' or pen.oipl_id is null) and se.session_id = userenv('sessionid')

View Text - HTML Formatted

SELECT PEN.PRTT_ENRT_RSLT_ID
, PEN.PL_ID
, PEN.OIPL_ID
, PEN.UOM
, PEN.ENRT_CVG_STRT_DT
, PEN.EFFECTIVE_START_DATE
, PEN.EFFECTIVE_END_DATE
, PEN.BUSINESS_GROUP_ID
, PEN.PERSON_ID
, PEN.ENRT_CVG_THRU_DT
, PEN.OBJECT_VERSION_NUMBER
, PEN.PER_IN_LER_ID
, PEN.BNFT_AMT
FROM BEN_PRTT_ENRT_RSLT_F PEN
, BEN_PL_F PL
, FND_SESSIONS SE
WHERE SE.EFFECTIVE_DATE BETWEEN PEN.EFFECTIVE_START_DATE
AND PEN.EFFECTIVE_END_DATE
AND SE.EFFECTIVE_DATE <= PEN.ENRT_CVG_THRU_DT
AND PEN.PRTT_ENRT_RSLT_STAT_CD IS NULL
AND PEN.PL_ID = PL.PL_ID
AND PEN.BUSINESS_GROUP_ID = PL.BUSINESS_GROUP_ID
AND PL.BNF_DSGN_CD IS NOT NULL
AND PL.PL_STAT_CD = 'A'
AND SE.EFFECTIVE_DATE BETWEEN PL.EFFECTIVE_START_DATE
AND PL.EFFECTIVE_END_DATE
AND (PL.SVGS_PL_FLAG <> 'Y' OR PEN.OIPL_ID IS NULL)
AND SE.SESSION_ID = USERENV('SESSIONID')