DBA Data[Home] [Help]

APPS.BEN_PREM_PL_OIPL_MONTHLY dependencies on BEN_TTL_PRTT_RT_F

Line 166: (select 'x' from ben_ttl_prtt_rt_f ttp

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
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)))