eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DETERMINE_DATE dependencies on BEN_LEE_RSN_F

Line 7163: ben_lee_rsn_f lee,

7159: lee.rt_strt_dt_rl,
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

Line 7193: ben_lee_rsn_f lee,

7189: lee.rt_strt_dt_rl,
7190: lee.rt_end_dt_cd,
7191: lee.rt_end_dt_rl
7192: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591
7193: ben_lee_rsn_f lee,
7194: ben_per_in_ler pil
7195: where popl.pgm_id = c_pgm_id
7196: and c_effective_date between popl.effective_start_date and popl.effective_end_date
7197: and lee.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id

Line 7297: from ben_lee_rsn_f

7293: rt_strt_dt_cd,
7294: rt_strt_dt_rl,
7295: rt_end_dt_cd,
7296: rt_end_dt_rl
7297: from ben_lee_rsn_f
7298: where lee_rsn_id=l_lee_rsn_id and
7299: business_group_id =p_business_group_id and
7300: nvl(p_lf_evt_ocrd_dt,p_effective_date) between
7301: effective_start_date and effective_end_date

Line 7444: from ben_lee_rsn_f lee

7440: lee.rt_strt_dt_cd,
7441: lee.rt_strt_dt_rl,
7442: lee.rt_end_dt_cd,
7443: lee.rt_end_dt_rl
7444: from ben_lee_rsn_f lee
7445: where lee.lee_rsn_id=c_lee_rsn_id
7446: and c_effective_date
7447: between lee.effective_start_date and lee.effective_end_date
7448: and ( enrt_cvg_strt_dt_cd is not null