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

Line 90: ben_oipl_f oipl

86: epe.pgm_id,
87: epe.pl_id,
88: epe.ptip_id
89: from ben_elig_per_elctbl_chc epe,
90: ben_oipl_f oipl
91: where epe.per_in_ler_id = p_per_in_ler_id
92: and epe.pl_id = p_pl_id
93: and epe.oipl_id = oipl.oipl_id
94: and epe.elctbl_flag = 'Y'

Line 419: from ben_oipl_f

415: l_oipl_id number ;
416: --
417: cursor c_oipl is
418: select oipl_id
419: from ben_oipl_f
420: where opt_id = p_opt_id
421: and pl_id = p_pl_id
422: and p_effective_date between effective_start_date
423: and effective_end_date;

Line 533: from ben_oipl_f

529: l_oipl_id number ;
530: --
531: cursor c_oipl is
532: select oipl_id
533: from ben_oipl_f
534: where opt_id = p_opt_id
535: and pl_id = p_pl_id
536: and p_effective_date between effective_start_date
537: and effective_end_date;

Line 775: ben_oipl_f oipl,

771: cursor c_pl_opt_name(p_epe_id number) is
772: select pln.name || ' '|| opt.name
773: from ben_elig_per_elctbl_chc epe,
774: ben_pl_f pln,
775: ben_oipl_f oipl,
776: ben_opt_f opt
777: where epe.elig_per_elctbl_chc_id = p_epe_id
778: and epe.pl_id = pln.pl_id
779: and epe.oipl_id = oipl.oipl_id(+)