DBA Data[Home] [Help]

APPS.BEN_BENBATCH_PERSONS dependencies on BEN_YR_PERD

Line 290: ben_yr_perd b,

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