APPS.BEN_PYR_BUS dependencies on BEN_PYRL_RT_F

Line 255: from ben_pyrl_rt_f

251: l_exists varchar2(1);
252: --
253: cursor c_dup is
254: select null
255: from ben_pyrl_rt_f
256: where payroll_id = p_payroll_id
257: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
258: and pyrl_rt_id <> nvl(p_pyrl_rt_id,hr_api.g_number)
259: and business_group_id + 0 = p_business_group_id

Line 336: from ben_pyrl_rt_f

332: is
333: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
334: l_dummy char(1);
335: cursor c1 is select null
336: from ben_pyrl_rt_f
337: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
338: -- changed against bug: 5113011
339: and pyrl_rt_id <> nvl(p_pyrl_rt_id ,-1)
340: --and payroll_id <> nvl(p_payroll_id ,-1)

Line 455: l_table_name := 'ben_pyrl_rt_f';

451: p_base_key_column => 'payroll_id',
452: p_base_key_value => p_payroll_id,
453: p_from_date => p_validation_start_date,
454: p_to_date => p_validation_end_date))) Then
455: l_table_name := 'ben_pyrl_rt_f';
456: Raise l_integrity_error;
457: End If;
458: --
459: End If;

Line 760: ben_pyrl_rt_f b

756: --
757: cursor csr_leg_code is
758: select a.legislation_code
759: from per_business_groups a,
760: ben_pyrl_rt_f b
761: where b.pyrl_rt_id = p_pyrl_rt_id
762: and a.business_group_id = b.business_group_id;
763: --
764: -- Declare local variables