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 165: ,ben_oipl_f b

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

Line 613: From ben_oipl_f oipl

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