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

Line 169: ,ben_oipl_f b

165: Select a.pgm_id, a.pl_typ_id, a.pl_id, a.oipl_id, b.opt_id
166: ,a.bnft_amt, a.uom
167: ,a.enrt_cvg_strt_dt, a.enrt_cvg_thru_dt
168: From ben_prtt_enrt_rslt_f a
169: ,ben_oipl_f b
170: Where a.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
171: and a.prtt_enrt_rslt_stat_cd is null
172: and p_effective_date between
173: a.effective_start_date and a.effective_end_date

Line 617: From ben_oipl_f oipl

613: ,p_batch_flag in boolean default FALSE
614: ) return varchar2 is
615: cursor c1 is
616: Select oipl.oipl_id, opt.opt_id, opt.name
617: From ben_oipl_f oipl
618: ,ben_opt_f opt
619: Where oipl.oipl_id = p_oipl_id
620: And oipl.opt_id = opt.opt_id
621: And oipl.business_group_id = p_business_group_id