DBA Data[Home] [Help]

APPS.BEN_BENBATCH_PERSONS dependencies on BEN_WTHN_YR_PERD

Line 288: ben_wthn_yr_perd c,

284: ,greatest(b.end_date
285: ,to_date(nvl(c.end_mo,1)||'/'||nvl(c.end_day,1)||'/'||to_char(b.end_date,'YYYY'),'MM/DD/YYYY')) wth_end_date
286: from BEN_ENRT_PERD A,
287: ben_yr_perd b,
288: ben_wthn_yr_perd c,
289: ben_popl_enrt_typ_cycl_f pet,
290: ben_ler_f ler
291: WHERE a.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
292: and a.yr_perd_id = b.yr_perd_id