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_DETERMINE_VARIABLE_RATES dependencies on BEN_OIPL_F

Line 424: from ben_oipl_f oipl

420: --
421: -- FONM
422: cursor c_opt(l_oipl_id number, cv_effective_date date) is
423: select opt_id
424: from ben_oipl_f oipl
425: where oipl_id = l_oipl_id
426: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
427: between oipl.effective_start_date
428: and oipl.effective_end_date;

Line 451: ben_oipl_f cop

447: cursor c_apr2(cv_effective_date date) is
448: select apr.actl_prem_id
449: from ben_actl_prem_f apr,
450: ben_pl_f pln,
451: ben_oipl_f cop
452: where ((pln.pl_id = l_epe.pl_id
453: and pln.actl_prem_id = apr.actl_prem_id
454: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
455: between pln.effective_start_date