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 2253: ben_acty_base_rt_f abr

2249: cursor c_future_prv is
2250: select prv.*
2251: from ben_prtt_rt_val prv,
2252: ben_prtt_enrt_rslt_f pen,
2253: ben_acty_base_rt_f abr
2254: where prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2255: and pen.person_id = p_person_id
2256: and prv.prtt_rt_val_stat_cd is null
2257: and prv.rt_strt_dt > p_rt_end_dt

Line 2261: (select element_type_id from ben_acty_base_rt_f abr2,

2257: and prv.rt_strt_dt > p_rt_end_dt
2258: and pen.prtt_enrt_rslt_stat_cd is null
2259: and prv.acty_base_rt_id = abr.acty_base_rt_id
2260: and abr.element_type_id =
2261: (select element_type_id from ben_acty_base_rt_f abr2,
2262: ben_prtt_rt_val prv2
2263: where abr2.acty_base_rt_id = prv2.acty_base_rt_id
2264: and prv2.prtt_rt_val_id = p_prtt_rt_val_id
2265: and prv2.rt_strt_dt between abr2.effective_start_date