DBA Data[Home] [Help]

APPS.BEN_PLAN_TYPE_API dependencies on BEN_ACTY_BASE_RT_F

Line 558: update ben_acty_base_rt_f

554: else
555: l_ordr_num := 1;
556: end if;
557: --
558: update ben_acty_base_rt_f
559: set ordr_num = l_ordr_num
560: where pl_id in (select pln.pl_id
561: from ben_pl_f pln
562: where pln.pl_typ_id = p_pl_typ_id

Line 570: update ben_acty_base_rt_f

566: and dsply_on_enrt_flag = 'Y';
567: --
568: -- plip level
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

Line 586: update ben_acty_base_rt_f

582: and dsply_on_enrt_flag = 'Y';
583: --
584: -- oipl level
585: --
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

Line 602: update ben_acty_base_rt_f

598: and dsply_on_enrt_flag = 'Y';
599: --
600: -- oiplip level
601: --
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,