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_PROVIDER_POOLS dependencies on BEN_OIPLIP_F

Line 290: ben_oipl_f oipl, ben_oiplip_f oiplip, ben_plip_f plip2

286: ptip.pl_typ_id,
287: nvl(plip.pl_id, plip2.pl_id) pl_id,
288: oipl.opt_id
289: from ben_bnft_prvdr_pool_f bpp, ben_ptip_f ptip, ben_plip_f plip,
290: ben_oipl_f oipl, ben_oiplip_f oiplip, ben_plip_f plip2
291: where p_effective_date between
292: bpp.effective_start_date and
293: bpp.effective_end_date and
294: bpp.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and

Line 807: from ben_prtt_enrt_rslt_f per,ben_oiplip_f oiplip,ben_plip_f cpp

803: p_epe_rec.pgm_id = per.pgm_id; -- Added : 4964766
804:
805: cursor c_oiplip_enrolment is
806: select 'x'
807: from ben_prtt_enrt_rslt_f per,ben_oiplip_f oiplip,ben_plip_f cpp
808: where per.person_id=p_person_id and
809: per.business_group_id=p_epe_rec.business_group_id and
810: per.prtt_enrt_rslt_id<>p_old_result_id and
811: per.sspndd_flag='N' and