110: */
111: /* Make sure that plan being linked to covers all the options that may
112: or may not have been stated by the user. */
113: and (exists (select null 114: from ben_oipl_f cop 115: where cop.opt_id = c_opt_id
116: and cop.pl_id = pln.pl_id
117: and cop.business_group_id = pln.business_group_id
118: and cop.oipl_stat_cd = 'A'