DBA Data[Home] [Help]

APPS.BEN_EXT_ENRT dependencies on BEN_YR_PERD

Line 741: from ben_yr_perd yrp,

737: --Bill Burns 05-Jul-2001
738: --
739: cursor c_pl_yr(l_prtt_enrt_rslt_id number) is
740: select yrp.start_date,yrp.end_date
741: from ben_yr_perd yrp,
742: ben_popl_yr_perd pop,
743: ben_prtt_enrt_rslt_f pen
744: where pop.yr_perd_id = yrp.yr_perd_id
745: and pop.pl_id = pen.pl_id

Line 754: from ben_yr_perd yrp,

750: and pop.business_group_id = pen.business_group_id;
751:
752: cursor c_pgm_yr(l_prtt_enrt_rslt_id number) is
753: select yrp.start_date,yrp.end_date
754: from ben_yr_perd yrp,
755: ben_popl_yr_perd pop,
756: ben_prtt_enrt_rslt_f pen
757: where pop.yr_perd_id = yrp.yr_perd_id
758: and pop.pgm_id = pen.pgm_id