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 7164: ben_ler_f ler,

7160: lee.rt_end_dt_cd,
7161: lee.rt_end_dt_rl
7162: from ben_popl_enrt_typ_cycl_f popl,
7163: ben_lee_rsn_f lee,
7164: ben_ler_f ler,
7165: ben_per_in_ler pil
7166: where popl.pl_id = c_pl_id
7167: and c_effective_date between popl.effective_start_date and popl.effective_end_date
7168: and lee.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id