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 6984: ben_lee_rsn_f lee,

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

Line 7014: ben_lee_rsn_f lee,

7010: lee.rt_strt_dt_rl,
7011: lee.rt_end_dt_cd,
7012: lee.rt_end_dt_rl
7013: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591
7014: ben_lee_rsn_f lee,
7015: ben_per_in_ler pil
7016: where popl.pgm_id = c_pgm_id
7017: and c_effective_date between popl.effective_start_date and popl.effective_end_date
7018: and lee.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id

Line 7118: from ben_lee_rsn_f

7114: rt_strt_dt_cd,
7115: rt_strt_dt_rl,
7116: rt_end_dt_cd,
7117: rt_end_dt_rl
7118: from ben_lee_rsn_f
7119: where lee_rsn_id=l_lee_rsn_id and
7120: business_group_id =p_business_group_id and
7121: nvl(p_lf_evt_ocrd_dt,p_effective_date) between
7122: effective_start_date and effective_end_date

Line 7265: from ben_lee_rsn_f lee

7261: lee.rt_strt_dt_cd,
7262: lee.rt_strt_dt_rl,
7263: lee.rt_end_dt_cd,
7264: lee.rt_end_dt_rl
7265: from ben_lee_rsn_f lee
7266: where lee.lee_rsn_id=c_lee_rsn_id
7267: and c_effective_date
7268: between lee.effective_start_date and lee.effective_end_date
7269: and ( enrt_cvg_strt_dt_cd is not null