DBA Data[Home] [Help]

APPS.BEN_PREM_PL_OIPL_MONTHLY dependencies on BEN_PL_R_OIPL_PREM_BY_MO_F

Line 610: from ben_pl_r_oipl_prem_by_mo_f pbm

606: l_ppe c_ppe%rowtype;
607:
608: cursor c_pbm (p_actl_prem_id number, p_mo_num number, p_yr_num number) is
609: select pbm.pl_r_oipl_prem_by_mo_id, pbm.object_version_number
610: from ben_pl_r_oipl_prem_by_mo_f pbm
611: where pbm.mo_num = p_mo_num
612: and pbm.yr_num = p_yr_num
613: and pbm.actl_prem_id = p_actl_prem_id ;
614: -- and p_effective_date between pbm.effective_start_date and pbm.effective_end_date; -- bug 2784213