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_PTIP_F

Line 307: from ben_bnft_prvdr_pool_f bpp, ben_ptip_f ptip, ben_plip_f plip,

303: bpp.pgm_id,
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

Line 666: ben_ptip_f pt

662: cursor c_ptip_enrolment is
663: select 'x'
664: from ben_prtt_enrt_rslt_f per,
665: ben_pl_f pl,
666: ben_ptip_f pt
667: where per.person_id=p_person_id and
668: per.business_group_id=p_epe_rec.business_group_id and
669: p_effective_date between
670: per.effective_start_date and per.effective_end_date and

Line 688: ben_ptip_f pt

684: cursor c_cmbn_ptip_enrolment is
685: select 'x'
686: from ben_prtt_enrt_rslt_f per,
687: ben_pl_f pl,
688: ben_ptip_f pt
689: where per.person_id=p_person_id and
690: per.business_group_id=p_epe_rec.business_group_id and
691: p_effective_date between
692: per.effective_start_date and per.effective_end_date and

Line 732: ben_ptip_f pt,

728: cursor c_cmbn_ptip_opt_enrolment is
729: select 'x'
730: from ben_prtt_enrt_rslt_f per,
731: ben_pl_f pl,
732: ben_ptip_f pt,
733: ben_oipl_f oipl,
734: ben_opt_f opt
735: where per.person_id=p_person_id and
736: per.business_group_id=p_epe_rec.business_group_id and