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 3366: from ben_oipl_f oipl

3362: -- 9999 cache this data and use it.
3363: --
3364: cursor c_group_oipl(cv_lf_evt_ocrd_dt in date) is
3365: select group_oipl.oipl_id
3366: from ben_oipl_f oipl
3367: ,ben_oipl_f group_oipl
3368: ,ben_pl_f pl
3369: ,ben_opt_f opt
3370: where oipl.oipl_id = p_oipl_id

Line 3367: ,ben_oipl_f group_oipl

3363: --
3364: cursor c_group_oipl(cv_lf_evt_ocrd_dt in date) is
3365: select group_oipl.oipl_id
3366: from ben_oipl_f oipl
3367: ,ben_oipl_f group_oipl
3368: ,ben_pl_f pl
3369: ,ben_opt_f opt
3370: where oipl.oipl_id = p_oipl_id
3371: and oipl.opt_id = opt.opt_id

Line 4768: from ben_oipl_f oipl

4764: --
4765: cursor c_oipl_exists(cv_lf_evt_ocrd_dt in date,
4766: cv_pl_id in number) is
4767: select oipl.oipl_id
4768: from ben_oipl_f oipl
4769: where oipl.pl_id = cv_pl_id
4770: and oipl.OIPL_STAT_CD = 'A'
4771: and cv_lf_evt_ocrd_dt between oipl.effective_start_date
4772: and oipl.effective_end_date