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