eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_TYPE_API dependencies on BEN_PL_F

Line 561: from ben_pl_f pln

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
563: and p_effective_date between pln.effective_start_date
564: and pln.effective_end_date)
565: and p_effective_date <= effective_end_date

Line 574: ben_pl_f pln

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
578: and pln.effective_end_date

Line 589: from ben_pl_f pln,

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
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

Line 607: ben_pl_f pln

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
611: and p_effective_date between pln.effective_start_date