209: -- Gets the enrolment information for this plan
210: --
211: cursor c_plan_enrolment_info(l_pl_id number) is
212: select pen.prtt_enrt_rslt_id
213: from ben_prtt_enrt_rslt_f pen
214: where pen.person_id=p_person_id and
215: pen.sspndd_flag='N' and
216: pen.prtt_enrt_rslt_stat_cd is null and
217: pen.effective_end_date = hr_api.g_eot and
224: -- Gets the enrolment information for this oipl
225: --
226: cursor c_oipl_enrolment_info(l_oipl_id number) is
227: select pen.prtt_enrt_rslt_id
228: from ben_prtt_enrt_rslt_f pen
229: where pen.person_id=p_person_id and
230: pen.sspndd_flag='N' and
231: pen.prtt_enrt_rslt_stat_cd is null and
232: pen.effective_end_date = hr_api.g_eot and