DBA Data[Home] [Help]

APPS.BEN_BENBATCH_PERSONS dependencies on BEN_ENRT_PERD

Line 286: from BEN_ENRT_PERD A,

282: select greatest (b.start_date
283: ,to_date(nvl(c.strt_mo,1) ||'/'||nvl(c.strt_day,1)||'/'||to_char(b.start_date,'YYYY'),'MM/DD/YYYY')) wth_start_date
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