DBA Data[Home] [Help]

APPS.BEN_PLAN_TYPE_API dependencies on BEN_OIPL_F

Line 590: ben_oipl_f oipl

586: update ben_acty_base_rt_f
587: set ordr_num = l_ordr_num
588: where oipl_id in (select oipl_id
589: from ben_pl_f pln,
590: ben_oipl_f oipl
591: where oipl.pl_id = pln.pl_id
592: and pln.pl_typ_id = p_pl_typ_id
593: and p_effective_date between pln.effective_start_date
594: and pln.effective_end_date

Line 606: ben_oipl_f oipl,

602: update ben_acty_base_rt_f
603: set ordr_num = l_ordr_num
604: where oiplip_id in (select oiplip_id
605: from ben_oiplip_f oiplip,
606: ben_oipl_f oipl,
607: ben_pl_f pln
608: where oipl.oipl_id = oiplip.oipl_id
609: and pln.pl_id = oipl.pl_id
610: and pln.pl_typ_id = p_pl_typ_id