348:
349: -- find the maximum number of times this communication can be sent
350: cursor c2 is
351: select mx_num_avlbl_val 352: from ben_cm_typ_f cct, ben_per_cm_f pcm 353: where pcm.per_cm_id = p_rec.per_cm_id
354: and pcm.cm_typ_id = cct.cm_typ_id
355: and p_effective_date between
356: pcm.effective_start_date and pcm.effective_end_date
[Home] [Help]