APPS.BEN_PBR_BUS dependencies on BEN_PY_BSS_RT_F

Line 247: from ben_py_bss_rt_f

243: l_exists varchar2(1);
244: --
245: cursor c_dup is
246: select null
247: from ben_py_bss_rt_f
248: where pay_basis_id = p_pay_basis_id
249: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
250: and py_bss_rt_id <> nvl(p_py_bss_rt_id,hr_api.g_number)
251: and business_group_id + 0 = p_business_group_id

Line 328: from ben_py_bss_rt_f

324: is
325: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
326: l_dummy char(1);
327: cursor c1 is select null
328: from ben_py_bss_rt_f
329: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
330: -- changed against bug: 5113011
331: and py_bss_rt_id <> nvl(p_py_bss_rt_id ,-1)
332: -- and pay_basis_id <> nvl(p_pay_basis_id ,-1)

Line 724: ben_py_bss_rt_f b

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