DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_OIPL_F

Line 620: ben_oipl_f oipl,

616: cursor c_pl_opt_name is
617: select pln.name || ' '|| opt.name
618: from ben_elig_per_elctbl_chc epe,
619: ben_pl_f pln,
620: ben_oipl_f oipl,
621: ben_opt_f opt
622: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
623: and epe.pl_id = pln.pl_id
624: and epe.oipl_id = oipl.oipl_id(+)

Line 708: from ben_oipl_f oipl

704: (c_effective_date in date
705: )
706: is
707: select opt_id
708: from ben_oipl_f oipl
709: where oipl.oipl_id = l_epe.oipl_id
710: and c_effective_date
711: between oipl.effective_start_date
712: and oipl.effective_end_date;

Line 819: ben_oipl_f cop

815: )
816: is
817: select ccm.cvg_amt_calc_mthd_id
818: from ben_cvg_amt_calc_mthd_f ccm,
819: ben_oipl_f cop
820: where cop.oipl_id = l_epe.oipl_id
821: and cop.oipl_id = ccm.oipl_id
822: and c_effective_date
823: between cop.effective_start_date