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 308: ben_oipl_f oipl, ben_oiplip_f oiplip, ben_plip_f plip2

304: ptip.pl_typ_id,
305: nvl(plip.pl_id, plip2.pl_id) pl_id,
306: oipl.opt_id
307: from ben_bnft_prvdr_pool_f bpp, ben_ptip_f ptip, ben_plip_f plip,
308: ben_oipl_f oipl, ben_oiplip_f oiplip, ben_plip_f plip2
309: where p_effective_date between
310: bpp.effective_start_date and
311: bpp.effective_end_date and
312: bpp.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and

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

821: p_epe_rec.pgm_id = per.pgm_id; -- Added : 4964766
822:
823: cursor c_oiplip_enrolment is
824: select 'x'
825: from ben_prtt_enrt_rslt_f per,ben_oiplip_f oiplip,ben_plip_f cpp
826: where per.person_id=p_person_id and
827: per.business_group_id=p_epe_rec.business_group_id and
828: per.prtt_enrt_rslt_id<>p_old_result_id and
829: per.sspndd_flag='N' and