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 (rt_hrly_slrd_flag = 'Y' or

Line 888: from ben_vrbl_rt_prfl_f

884: l_vrbl_usg_cd varchar2(30);
885: --
886: cursor c1 is
887: select mlt_cd, vrbl_usg_cd
888: from ben_vrbl_rt_prfl_f
889: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
890: and business_group_id = p_business_group_id
891: and p_effective_date between effective_start_date and effective_end_date;
892: --