343: l_proc varchar2(72) := g_package||'pre_insert';
344:
345: cursor c1 is
346: select ben_per_cm_prvdd_f_s.nextval 347: from dual; 348:
349: -- find the maximum number of times this communication can be sent
350: cursor c2 is
351: select mx_num_avlbl_val