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_BACK_OUT_LIFE_EVENT dependencies on BEN_ACTY_BASE_RT_F

Line 2638: ben_acty_base_rt_f abr

2634: cursor c_future_prv is
2635: select prv.*
2636: from ben_prtt_rt_val prv,
2637: ben_prtt_enrt_rslt_f pen,
2638: ben_acty_base_rt_f abr
2639: where prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2640: and pen.person_id = p_person_id
2641: and prv.prtt_rt_val_stat_cd is null
2642: and prv.rt_strt_dt > p_rt_end_dt

Line 2646: (select element_type_id from ben_acty_base_rt_f abr2,

2642: and prv.rt_strt_dt > p_rt_end_dt
2643: and pen.prtt_enrt_rslt_stat_cd is null
2644: and prv.acty_base_rt_id = abr.acty_base_rt_id
2645: and abr.element_type_id =
2646: (select element_type_id from ben_acty_base_rt_f abr2,
2647: ben_prtt_rt_val prv2
2648: where abr2.acty_base_rt_id = prv2.acty_base_rt_id
2649: and prv2.prtt_rt_val_id = p_prtt_rt_val_id
2650: and prv2.rt_strt_dt between abr2.effective_start_date