APPS.BEN_PROVIDER_POOLS dependencies on BEN_PTIP_F

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

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

Line 648: ben_ptip_f pt

644: cursor c_ptip_enrolment is
645: select 'x'
646: from ben_prtt_enrt_rslt_f per,
647: ben_pl_f pl,
648: ben_ptip_f pt
649: where per.person_id=p_person_id and
650: per.business_group_id=p_epe_rec.business_group_id and
651: p_effective_date between
652: per.effective_start_date and per.effective_end_date and

Line 670: ben_ptip_f pt

666: cursor c_cmbn_ptip_enrolment is
667: select 'x'
668: from ben_prtt_enrt_rslt_f per,
669: ben_pl_f pl,
670: ben_ptip_f pt
671: where per.person_id=p_person_id and
672: per.business_group_id=p_epe_rec.business_group_id and
673: p_effective_date between
674: per.effective_start_date and per.effective_end_date and

Line 714: ben_ptip_f pt,

710: cursor c_cmbn_ptip_opt_enrolment is
711: select 'x'
712: from ben_prtt_enrt_rslt_f per,
713: ben_pl_f pl,
714: ben_ptip_f pt,
715: ben_oipl_f oipl,
716: ben_opt_f opt
717: where per.person_id=p_person_id and
718: per.business_group_id=p_epe_rec.business_group_id and