DBA Data[Home] [Help]

APPS.BEN_BENBATCH_PERSONS dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 292: ben_popl_enrt_typ_cycl_f pet,

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
295: and a.yr_perd_id = b.yr_perd_id
296: and a.wthn_yr_perd_id = c.wthn_yr_perd_id (+)