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_OIPL_F

Line 3314: from ben_oipl_f oipl

3310: -- 9999 cache this data and use it.
3311: --
3312: cursor c_group_oipl(cv_lf_evt_ocrd_dt in date) is
3313: select group_oipl.oipl_id
3314: from ben_oipl_f oipl
3315: ,ben_oipl_f group_oipl
3316: ,ben_pl_f pl
3317: ,ben_opt_f opt
3318: where oipl.oipl_id = p_oipl_id

Line 3315: ,ben_oipl_f group_oipl

3311: --
3312: cursor c_group_oipl(cv_lf_evt_ocrd_dt in date) is
3313: select group_oipl.oipl_id
3314: from ben_oipl_f oipl
3315: ,ben_oipl_f group_oipl
3316: ,ben_pl_f pl
3317: ,ben_opt_f opt
3318: where oipl.oipl_id = p_oipl_id
3319: and oipl.opt_id = opt.opt_id

Line 4716: from ben_oipl_f oipl

4712: --
4713: cursor c_oipl_exists(cv_lf_evt_ocrd_dt in date,
4714: cv_pl_id in number) is
4715: select oipl.oipl_id
4716: from ben_oipl_f oipl
4717: where oipl.pl_id = cv_pl_id
4718: and oipl.OIPL_STAT_CD = 'A'
4719: and cv_lf_evt_ocrd_dt between oipl.effective_start_date
4720: and oipl.effective_end_date