DBA Data[Home] [Help]

APPS.BEN_PLAN_TYPE_API dependencies on BEN_PLIP_F

Line 573: from ben_plip_f plip,

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