APPS.BEN_HSR_BUS dependencies on BEN_HRLY_SLRD_RT_F

Line 266: from ben_hrly_slrd_rt_f

262: l_exists varchar2(1);
263: --
264: cursor c_dup is
265: select null
266: from ben_hrly_slrd_rt_f
267: where hrly_slrd_cd = p_hrly_slrd_cd
268: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
269: and hrly_slrd_rt_id <> nvl(p_hrly_slrd_rt_id,hr_api.g_number)
270: and business_group_id + 0 = p_business_group_id

Line 346: from ben_hrly_slrd_rt_f

342: is
343: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
344: l_dummy char(1);
345: cursor c1 is select null
346: from ben_hrly_slrd_rt_f
347: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
348: -- changed against bug: 5113011
349: and hrly_slrd_rt_id <> nvl(p_hrly_slrd_rt_id,-1)
350: --and hrly_slrd_cd <> nvl(p_hrly_slrd_cd,-1)

Line 748: ben_hrly_slrd_rt_f b

744: --
745: cursor csr_leg_code is
746: select a.legislation_code
747: from per_business_groups a,
748: ben_hrly_slrd_rt_f b
749: where b.hrly_slrd_rt_id = p_hrly_slrd_rt_id
750: and a.business_group_id = b.business_group_id;
751: --
752: -- Declare local variables