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_ACTL_PREM_F

Line 309: from ben_actl_prem_f ava

305: --
306: -- FONM
307: cursor c_ava(cv_effective_date date) is
308: select ava.vrbl_rt_add_on_calc_rl
309: from ben_actl_prem_f ava
310: where ava.actl_prem_id = p_actl_prem_id
311: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
312: between ava.effective_start_date
313: and ava.effective_end_date;

Line 415: from ben_actl_prem_f apr,

411:
412: -- FONM
413: cursor c_apr2(cv_effective_date date) is
414: select apr.actl_prem_id
415: from ben_actl_prem_f apr,
416: ben_pl_f pln,
417: ben_oipl_f cop
418: where ((pln.pl_id = l_epe.pl_id
419: and pln.actl_prem_id = apr.actl_prem_id