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 2565: l_oipl_name ben_opt_f.name%TYPE;

2561: --l_overide_enrt_cvg_strt_dt_cd varchar2(30);
2562: --l_overide_enrt_cvg_strt_dt_rl number;
2563: l_pl_id NUMBER;
2564: l_prereq_electable_flag VARCHAR2(30);
2565: l_oipl_name ben_opt_f.name%TYPE;
2566: l_pl_name ben_pl_f.name%TYPE;
2567: l_ler_name ben_ler_f.name%TYPE;
2568: l_must_enrl_anthr_pl_id NUMBER;
2569: l_auto_enrt_flag VARCHAR2(30) := 'N';

Line 3568: from ben_opt_f opt

3564: ;
3565: --
3566: cursor c_opt_requery(p_id number,p_ed date) is
3567: select 'Y'
3568: from ben_opt_f opt
3569: where opt_id=p_id and
3570: business_group_id=p_business_group_id and
3571: p_ed between effective_start_date and effective_end_date
3572: ;

Line 9380: FROM ben_opt_f bo

9376: SELECT '2',
9377: bo.rqd_perd_enrt_nenrt_uom,
9378: bo.rqd_perd_enrt_nenrt_val,
9379: bo.rqd_perd_enrt_nenrt_rl
9380: FROM ben_opt_f bo
9381: WHERE bo.opt_id = p_opt_id
9382: AND p_effective_date BETWEEN bo.effective_start_date
9383: AND bo.effective_end_date
9384: AND bo.business_group_id = p_business_group_id