APPS.BEN_PROVIDER_POOLS dependencies on BEN_PL_F

Line 647: ben_pl_f pl,

643:
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

Line 669: ben_pl_f pl,

665:
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

Line 691: ben_pl_f pl,

687:
688: cursor c_cmbn_plip_enrolment is
689: select 'x'
690: from ben_prtt_enrt_rslt_f per,
691: ben_pl_f pl,
692: ben_plip_f cpp
693: where per.person_id=p_person_id and
694: per.business_group_id=p_epe_rec.business_group_id and
695: p_effective_date between

Line 713: ben_pl_f pl,

709: /* bug 1285336
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

Line 745: ben_pl_f pl,

741: */
742: cursor c_cmbn_ptip_opt_enrolment is
743: select 'x'
744: from ben_prtt_enrt_rslt_f per,
745: ben_pl_f pl,
746: ben_optip_f otp,
747: ben_oipl_f oipl
748: where per.person_id=p_person_id and
749: per.business_group_id=p_epe_rec.business_group_id and