569: --
570: update ben_acty_base_rt_f
571: set ordr_num = l_ordr_num
572: where plip_id in (select plip_id 573: from ben_plip_f plip, 574: ben_pl_f pln
575: where pln.pl_id = plip.pl_id
576: and pln.pl_typ_id = p_pl_typ_id
577: and p_effective_date between pln.effective_start_date