APPS.BEN_BUR_BUS dependencies on BEN_BRGNG_UNIT_RT_F

Line 196: from ben_brgng_unit_rt_f

192: l_exists varchar2(1);
193: --
194: cursor c_dup is
195: select null
196: from ben_brgng_unit_rt_f
197: where brgng_unit_cd = p_brgng_unit_cd
198: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
199: and brgng_unit_rt_id <> nvl(p_brgng_unit_rt_id,hr_api.g_number)
200: and business_group_id + 0 = p_business_group_id

Line 474: from ben_brgng_unit_rt_f

470: is
471: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
472: l_dummy char(1);
473: cursor c1 is select null
474: from ben_brgng_unit_rt_f
475: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
476: -- and asnt_set_rt_id <> nvl(p_asnt_set_rt_id,-1)
477: and p_effective_date between effective_start_date
478: and effective_end_date

Line 742: ben_brgng_unit_rt_f b

738: --
739: cursor csr_leg_code is
740: select a.legislation_code
741: from per_business_groups a,
742: ben_brgng_unit_rt_f b
743: where b.brgng_unit_rt_id = p_brgng_unit_rt_id
744: and a.business_group_id = b.business_group_id;
745: --
746: -- Declare local variables