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_ENROLMENT_REQUIREMENTS dependencies on BEN_OPT_F

Line 2538: l_oipl_name ben_opt_f.name%TYPE;

2534: --l_overide_enrt_cvg_strt_dt_cd varchar2(30);
2535: --l_overide_enrt_cvg_strt_dt_rl number;
2536: l_pl_id NUMBER;
2537: l_prereq_electable_flag VARCHAR2(30);
2538: l_oipl_name ben_opt_f.name%TYPE;
2539: l_pl_name ben_pl_f.name%TYPE;
2540: l_ler_name ben_ler_f.name%TYPE;
2541: l_must_enrl_anthr_pl_id NUMBER;
2542: l_auto_enrt_flag VARCHAR2(30) := 'N';

Line 3522: from ben_opt_f opt

3518: ;
3519: --
3520: cursor c_opt_requery(p_id number,p_ed date) is
3521: select 'Y'
3522: from ben_opt_f opt
3523: where opt_id=p_id and
3524: business_group_id=p_business_group_id and
3525: p_ed between effective_start_date and effective_end_date
3526: ;

Line 9241: FROM ben_opt_f bo

9237: SELECT '2',
9238: bo.rqd_perd_enrt_nenrt_uom,
9239: bo.rqd_perd_enrt_nenrt_val,
9240: bo.rqd_perd_enrt_nenrt_rl
9241: FROM ben_opt_f bo
9242: WHERE bo.opt_id = p_opt_id
9243: AND p_effective_date BETWEEN bo.effective_start_date
9244: AND bo.effective_end_date
9245: AND bo.business_group_id = p_business_group_id