APPS.BEN_VPR_BUS dependencies on BEN_VRBL_RT_PRFL_RL_F

Line 182: from ben_vrbl_rt_prfl_rl_f

178: is
179: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
180: l_dummy char(1);
181: cursor c1 is select null
182: from ben_vrbl_rt_prfl_rl_f
183: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
184: and vrbl_rt_prfl_rl_id <> nvl(p_vrbl_rt_prfl_rl_id,-1)
185: and p_effective_date between effective_start_date
186: and effective_end_date

Line 348: from ben_vrbl_rt_prfl_rl_f

344: l_exists varchar2(1);
345: --
346: cursor c_dup is
347: select null
348: from ben_vrbl_rt_prfl_rl_f
349: where formula_id = p_formula_id
350: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
351: and vrbl_rt_prfl_rl_id <> nvl(p_vrbl_rt_prfl_rl_id,hr_api.g_number)
352: and business_group_id + 0 = p_business_group_id

Line 757: ben_vrbl_rt_prfl_rl_f b

753: --
754: cursor csr_leg_code is
755: select a.legislation_code
756: from per_business_groups a,
757: ben_vrbl_rt_prfl_rl_f b
758: where b.vrbl_rt_prfl_rl_id = p_vrbl_rt_prfl_rl_id
759: and a.business_group_id = b.business_group_id;
760: --
761: -- Declare local variables