APPS.BEN_WLR_BUS dependencies on BEN_WK_LOC_RT_F

Line 246: from ben_wk_loc_rt_f

242: l_exists varchar2(1);
243: --
244: cursor c_dup is
245: select null
246: from ben_wk_loc_rt_f
247: where location_id = p_location_id
248: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
249: and wk_loc_rt_id <> nvl(p_wk_loc_rt_id,hr_api.g_number)
250: and business_group_id + 0 = p_business_group_id

Line 326: from ben_wk_loc_rt_f

322: is
323: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
324: l_dummy char(1);
325: cursor c1 is select null
326: from ben_wk_loc_rt_f
327: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
328: -- changed against bug: 5113011
329: and wk_loc_rt_id <> nvl(p_wk_loc_rt_id ,-1)
330: -- and location_id <> nvl(p_location_id ,-1)

Line 724: ben_wk_loc_rt_f b

720: --
721: cursor csr_leg_code is
722: select a.legislation_code
723: from per_business_groups a,
724: ben_wk_loc_rt_f b
725: where b.wk_loc_rt_id = p_wk_loc_rt_id
726: and a.business_group_id = b.business_group_id;
727: --
728: -- Declare local variables