324:
325: cursor c_oipl_prtn(v_oipl_id number) is
326: select prtn.prtn_elig_id
327: ,prtn.object_version_number
328: from ben_prtn_elig_f prtn
329: where prtn.oipl_id = v_oipl_id
330: and p_effective_date between
331: prtn.effective_start_date and prtn.effective_end_date;
332:
332:
333: cursor c_pl_prtn(v_pl_id number) is
334: select prtn.prtn_elig_id
335: ,prtn.object_version_number
336: from ben_prtn_elig_f prtn
337: where prtn.pl_id = v_pl_id
338: and p_effective_date between
339: prtn.effective_start_date and prtn.effective_end_date;
340: