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 87: ben_oipl_f oipl

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

Line 416: from ben_oipl_f

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

Line 530: from ben_oipl_f

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

Line 772: ben_oipl_f oipl,

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