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 343: from ben_actl_prem_f ava

339: --
340: -- FONM
341: cursor c_ava(cv_effective_date date) is
342: select ava.vrbl_rt_add_on_calc_rl
343: from ben_actl_prem_f ava
344: where ava.actl_prem_id = p_actl_prem_id
345: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
346: between ava.effective_start_date
347: and ava.effective_end_date;

Line 449: from ben_actl_prem_f apr,

445:
446: -- FONM
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