308: */
309: CURSOR c_waive_pl_opt IS
310: SELECT NULL
311: FROM ben_oipl_f oipl, 312: ben_opt_f opt 313: WHERE oipl.opt_id = opt.opt_id
314: AND oipl.oipl_id = p_new_oipl_id
315: AND p_effective_date BETWEEN oipl.effective_start_date AND oipl.effective_end_date
316: AND p_effective_date BETWEEN opt.effective_start_date AND opt.effective_end_date