APPS.BEN_AVR_BUS dependencies on BEN_ACTY_VRBL_RT_F

Line 307: from ben_acty_vrbl_rt_f

303: is
304: l_proc varchar2(72) := g_package||'chk_ordr_num_unique';
305: l_dummy char(1);
306: cursor c1 is select null
307: from ben_acty_vrbl_rt_f
308: Where acty_vrbl_rt_id <> nvl(p_acty_vrbl_rt_id,-1)
309: and acty_base_rt_id = p_acty_base_rt_id
310: and ordr_num = p_ordr_num
311: and business_group_id = p_business_group_id;

Line 442: from ben_acty_vrbl_rt_f avr

438: l_dummy char(1);
439: --
440: cursor c_dup_vrbl_rt_prfl is
441: select null
442: from ben_acty_vrbl_rt_f avr
443: where avr.acty_base_rt_id = p_acty_base_rt_id
444: and avr.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
445: and avr.acty_vrbl_rt_id <> nvl(p_acty_vrbl_rt_id, hr_api.g_number)
446: and avr.business_group_id = p_business_group_id

Line 873: ben_acty_vrbl_rt_f b

869: --
870: cursor csr_leg_code is
871: select a.legislation_code
872: from per_business_groups a,
873: ben_acty_vrbl_rt_f b
874: where b.acty_vrbl_rt_id = p_acty_vrbl_rt_id
875: and a.business_group_id = b.business_group_id;
876: --
877: -- Declare local variables