DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DATE dependencies on BEN_LER_F

Line 185: ben_ler_f ler

181: cursor c_mode
182: is
183: select 1
184: from ben_per_in_ler pil,
185: ben_ler_f ler
186: where pil.ler_id = ler.ler_id
187: and pil.per_in_ler_id=p_per_in_ler_id
188: and ler.typ_cd not like 'SCHED%'
189: and p_lf_evt_ocrd_dt between effective_start_date and effective_end_date;

Line 6985: ben_ler_f ler,

6981: lee.rt_end_dt_cd,
6982: lee.rt_end_dt_rl
6983: from ben_popl_enrt_typ_cycl_f popl,
6984: ben_lee_rsn_f lee,
6985: ben_ler_f ler,
6986: ben_per_in_ler pil
6987: where popl.pl_id = c_pl_id
6988: and c_effective_date between popl.effective_start_date and popl.effective_end_date
6989: and lee.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id