448: -- Gets the enrolment information for this plan
449: --
450: cursor c_plan_enrolment_info is
451: select prtt_enrt_rslt_id
452: from ben_prtt_enrt_rslt_f pen
453: where pen.person_id=p_person_id and
454: pen.business_group_id =p_business_group_id and
455: --pen.sspndd_flag='N' and --5127698
456: pen.prtt_enrt_rslt_stat_cd is null and
464: -- Gets the enrolment information for this oipl
465: --
466: cursor c_oipl_enrolment_info is
467: select prtt_enrt_rslt_id
468: from ben_prtt_enrt_rslt_f pen
469: where pen.person_id=p_person_id and
470: pen.business_group_id =p_business_group_id and
471: --pen.sspndd_flag='N' and --5127698
472: pen.prtt_enrt_rslt_stat_cd is null and