DBA Data[Home] [Help]

APPS.BEN_CCM_BUS dependencies on BEN_OIPLIP_F

Line 212: ben_acty_base_rt_f a ,ben_oiplip_f b where a.oiplip_id = b.oiplip_id and

208: rt_mlt_cd = 'CVG' and entr_val_at_enrt_flag = 'Y' and
209: p_effective_date between effective_start_date and effective_end_date ;
210:
211: cursor c_oiplip is select 'x' from
212: ben_acty_base_rt_f a ,ben_oiplip_f b where a.oiplip_id = b.oiplip_id and
213: a.rt_mlt_cd = 'CVG' and a.entr_val_at_enrt_flag = 'Y' and
214: p_effective_date between a.effective_start_date and a.effective_end_date and
215: b.oipl_id = p_oipl_id and p_effective_date between b.effective_start_date and b.effective_end_date ;
216: