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

Line 445: from ben_acty_base_rt_f

441: l_outputs ff_exec.outputs_t;
442:
443: cursor c_abr is
444: select element_det_rl
445: from ben_acty_base_rt_f
446: where acty_base_rt_id = p_acty_base_rt_id
447: and p_effective_date between effective_start_date
448: and effective_end_date;
449:

Line 4723: from ben_acty_base_rt_f abr

4719: and cv_lf_evt_ocrd_dt between oipl.effective_start_date
4720: and oipl.effective_end_date
4721: and exists
4722: (select null
4723: from ben_acty_base_rt_f abr
4724: where abr.pl_id = cv_pl_id
4725: and cv_lf_evt_ocrd_dt between abr.effective_start_date
4726: and abr.effective_end_date
4727: and abr.acty_typ_cd = 'CWBWS' -- 9999