eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CCM_BUS dependencies on BEN_ACTY_BASE_RT_F

Line 197: ben_acty_base_rt_f where pl_id = p_pl_id and

193: l_dummy varchar2(1) ;
194: l_proc varchar2(72) := g_package||'chk_entr_at_enrt_with_rate';
195:
196: cursor c_pl is select 'x' from
197: ben_acty_base_rt_f where pl_id = p_pl_id and
198: rt_mlt_cd = 'CVG' and entr_val_at_enrt_flag = 'Y' and
199: p_effective_date between effective_start_date and effective_end_date ;
200:
201: cursor c_plip is select 'x' from ben_acty_base_rt_f a , ben_plip_f b where

Line 201: cursor c_plip is select 'x' from ben_acty_base_rt_f a , ben_plip_f b where

197: ben_acty_base_rt_f where pl_id = p_pl_id and
198: rt_mlt_cd = 'CVG' and entr_val_at_enrt_flag = 'Y' and
199: p_effective_date between effective_start_date and effective_end_date ;
200:
201: cursor c_plip is select 'x' from ben_acty_base_rt_f a , ben_plip_f b where
202: a.plip_id = b.plip_id and a.rt_mlt_cd = 'CVG' and a.entr_val_at_enrt_flag = 'Y' and
203: p_effective_date between a.effective_start_date and a.effective_end_date and
204: b.pl_id = p_pl_id and p_effective_date between b.effective_start_date and b.effective_end_date;
205:

Line 207: ben_acty_base_rt_f where oipl_id = p_oipl_id and

203: p_effective_date between a.effective_start_date and a.effective_end_date and
204: b.pl_id = p_pl_id and p_effective_date between b.effective_start_date and b.effective_end_date;
205:
206: cursor c_oipl is select 'x' from
207: ben_acty_base_rt_f where oipl_id = p_oipl_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

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: