DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on BEN_VRBL_RT_PRFL_F

Line 321: ben_vrbl_rt_prfl_f vpf

317: l_dummy varchar2(1) := null ;
318: --
319: cursor c_vrbl_rt_flags is
320: select 'X' from
321: ben_vrbl_rt_prfl_f vpf
322: where
323: vpf.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
324: and p_effective_date between vpf.effective_start_date and vpf.effective_end_date
325: and (

Line 1002: from ben_vrbl_rt_prfl_f

998: l_vrbl_usg_cd varchar2(30);
999: --
1000: cursor c1 is
1001: select mlt_cd, vrbl_usg_cd
1002: from ben_vrbl_rt_prfl_f
1003: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
1004: and business_group_id = p_business_group_id
1005: and p_effective_date between effective_start_date and effective_end_date;
1006: --