APPS.BEN_PREM_PL_OIPL_MONTHLY dependencies on BEN_TTL_CVG_VOL_RT_F

Line 169: (select 'x' from ben_ttl_cvg_vol_rt_f tcv

165: and ((vpf.alwys_cnt_all_prtts_flag = 'N' and exists
166: (select 'x' from ben_ttl_prtt_rt_f ttp
167: where ttp.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id))
168: or (vpf.alwys_sum_all_cvg_flag = 'N'and exists
169: (select 'x' from ben_ttl_cvg_vol_rt_f tcv
170: where tcv.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id)))
171: and vpf.business_group_id = p_business_group_id
172: and p_effective_date between
173: vpf.effective_start_date and vpf.effective_end_date;