401: AND p_effective_date BETWEEN opt.effective_start_date AND opt.effective_end_date
402: AND NVL (opt.invk_wv_opt_flag, 'N') = 'Y'
403: UNION
404: SELECT NULL 405: FROM ben_pl_f pln 406: WHERE pln.pl_id = p_new_pl_id
407: AND p_effective_date BETWEEN pln.effective_start_date AND pln.effective_end_date
408: AND NVL (pln.invk_dcln_prtn_pl_flag, 'N') = 'Y';
409: