DBA Data[Home] [Help]

APPS.BEN_EXT_ENRT dependencies on BEN_POPL_YR_PERD

Line 742: ben_popl_yr_perd pop,

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
746: and p_effective_date between yrp.start_date and nvl(yrp.end_date,p_effective_date)

Line 755: ben_popl_yr_perd pop,

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
759: and p_effective_date between yrp.start_date and nvl(yrp.end_date,p_effective_date)