APPS.BEN_PREM_PL_OIPL_MONTHLY dependencies on BEN_VRBL_RT_PRFL_F

Line 152: from ben_vrbl_rt_prfl_f vpf

148: cursor c_vrbl_val (p_vrbl_rt_prfl_id number) is
149: select nvl(vpf.val,0) val, vpf.upr_lmt_val, vpf.upr_lmt_calc_rl
150: ,vpf.lwr_lmt_val, vpf.lwr_lmt_calc_rl, vpf.rndg_cd,
151: vpf.rndg_rl, vpf.bnft_rt_typ_cd, vpf.mlt_cd
152: from ben_vrbl_rt_prfl_f vpf
153: where vpf.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
154: and vpf.business_group_id = p_business_group_id
155: and p_effective_date between
156: vpf.effective_start_date and vpf.effective_end_date;

Line 162: from ben_vrbl_rt_prfl_f vpf, ben_actl_prem_vrbl_rt_f apv

158:
159: -- make sure flags default to 'Y' ??
160: cursor c_alwys_cnt_no is
161: select 'Y'
162: from ben_vrbl_rt_prfl_f vpf, ben_actl_prem_vrbl_rt_f apv
163: where apv.actl_prem_id = p_actl_prem_id
164: and apv.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id
165: and ((vpf.alwys_cnt_all_prtts_flag = 'N' and exists
166: (select 'x' from ben_ttl_prtt_rt_f ttp