APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_PRTT_ENRT_RSLT_F

Line 450: from ben_prtt_enrt_rslt_f pen

446: -- Gets the enrolment information for this plan
447: --
448: cursor c_plan_enrolment_info is
449: select prtt_enrt_rslt_id
450: from ben_prtt_enrt_rslt_f pen
451: where pen.person_id=p_person_id and
452: pen.business_group_id =p_business_group_id and
453: --pen.sspndd_flag='N' and --5127698
454: pen.prtt_enrt_rslt_stat_cd is null and

Line 466: from ben_prtt_enrt_rslt_f pen

462: -- Gets the enrolment information for this oipl
463: --
464: cursor c_oipl_enrolment_info is
465: select prtt_enrt_rslt_id
466: from ben_prtt_enrt_rslt_f pen
467: where pen.person_id=p_person_id and
468: pen.business_group_id =p_business_group_id and
469: --pen.sspndd_flag='N' and --5127698
470: pen.prtt_enrt_rslt_stat_cd is null and