APPS.BEN_PROVIDER_POOLS dependencies on BEN_PL_F

Line 665: ben_pl_f pl,

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

Line 687: ben_pl_f pl,

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

Line 709: ben_pl_f pl,

705:
706: cursor c_cmbn_plip_enrolment is
707: select 'x'
708: from ben_prtt_enrt_rslt_f per,
709: ben_pl_f pl,
710: ben_plip_f cpp
711: where per.person_id=p_person_id and
712: per.business_group_id=p_epe_rec.business_group_id and
713: p_effective_date between

Line 731: ben_pl_f pl,

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

Line 763: ben_pl_f pl,

759: */
760: cursor c_cmbn_ptip_opt_enrolment is
761: select 'x'
762: from ben_prtt_enrt_rslt_f per,
763: ben_pl_f pl,
764: ben_optip_f otp,
765: ben_oipl_f oipl
766: where per.person_id=p_person_id and
767: per.business_group_id=p_epe_rec.business_group_id and