DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_OIPL_F

Line 603: ben_oipl_f oipl,

599: cursor c_pl_opt_name is
600: select pln.name || ' '|| opt.name
601: from ben_elig_per_elctbl_chc epe,
602: ben_pl_f pln,
603: ben_oipl_f oipl,
604: ben_opt_f opt
605: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
606: and epe.pl_id = pln.pl_id
607: and epe.oipl_id = oipl.oipl_id(+)

Line 691: from ben_oipl_f oipl

687: (c_effective_date in date
688: )
689: is
690: select opt_id
691: from ben_oipl_f oipl
692: where oipl.oipl_id = l_epe.oipl_id
693: and c_effective_date
694: between oipl.effective_start_date
695: and oipl.effective_end_date;

Line 802: ben_oipl_f cop

798: )
799: is
800: select ccm.cvg_amt_calc_mthd_id
801: from ben_cvg_amt_calc_mthd_f ccm,
802: ben_oipl_f cop
803: where cop.oipl_id = l_epe.oipl_id
804: and cop.oipl_id = ccm.oipl_id
805: and c_effective_date
806: between cop.effective_start_date