APPS.BEN_VPF_BUS dependencies on BEN_VRBL_RT_PRFL_F

Line 315: from ben_vrbl_rt_prfl_f

311: is
312: l_proc varchar2(72) := g_package||'chk_name_unique';
313: l_dummy char(1);
314: cursor c1 is select null
315: from ben_vrbl_rt_prfl_f
316: Where vrbl_rt_prfl_id <> nvl(p_vrbl_rt_prfl_id,-1)
317: and name = p_name
318: and business_group_id = p_business_group_id;
319: --

Line 4680: p_parent_table_name => 'BEN_VRBL_RT_PRFL_F',

4676: -- A referential integrity check was violated therefore
4677: -- we must error
4678: --
4679: ben_utility.child_exists_error(p_table_name => 'BEN_VRBL_RT_PRFL_CRITERIA',
4680: p_parent_table_name => 'BEN_VRBL_RT_PRFL_F',
4681: p_parent_entity_name => p_name);
4682: --
4683: When l_rows_exist Then
4684: --

Line 4689: p_parent_table_name => 'BEN_VRBL_RT_PRFL_F',

4685: -- A referential integrity check was violated therefore
4686: -- we must error
4687: --
4688: ben_utility.child_exists_error(p_table_name => l_table_name,
4689: p_parent_table_name => 'BEN_VRBL_RT_PRFL_F',
4690: p_parent_entity_name => p_name);
4691: --
4692: When Others Then
4693: --

Line 5548: FROM ben_vrbl_rt_prfl_f vpf

5544: --
5545: CURSOR c_vpf_name
5546: IS
5547: SELECT vpf.NAME
5548: FROM ben_vrbl_rt_prfl_f vpf
5549: WHERE vpf.vrbl_rt_prfl_id = p_rec.vrbl_rt_prfl_id
5550: AND p_effective_date BETWEEN vpf.effective_start_date
5551: AND vpf.effective_end_date;
5552: --

Line 5553: l_vpf_name ben_vrbl_rt_prfl_f.name%type;

5549: WHERE vpf.vrbl_rt_prfl_id = p_rec.vrbl_rt_prfl_id
5550: AND p_effective_date BETWEEN vpf.effective_start_date
5551: AND vpf.effective_end_date;
5552: --
5553: l_vpf_name ben_vrbl_rt_prfl_f.name%type;
5554: --
5555: Begin
5556: hr_utility.set_location('Entering:'||l_proc, 5);
5557: --

Line 5589: ben_vrbl_rt_prfl_f b

5585: --
5586: cursor csr_leg_code is
5587: select a.legislation_code
5588: from per_business_groups a,
5589: ben_vrbl_rt_prfl_f b
5590: where b.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
5591: and a.business_group_id = b.business_group_id;
5592: --
5593: -- Declare local variables