APPS.BEN_ASR_BUS dependencies on BEN_ASNT_SET_RT_F

Line 128: from ben_asnt_set_rt_f

124: l_exists varchar2(1);
125: --
126: cursor c_dup is
127: select null
128: from ben_asnt_set_rt_f
129: where assignment_set_id = p_assignment_set_id
130: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
131: and asnt_set_rt_id <> nvl(p_asnt_set_rt_id,hr_api.g_number)
132: and business_group_id + 0 = p_business_group_id

Line 275: from ben_asnt_set_rt_f

271: is
272: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
273: l_dummy char(1);
274: cursor c1 is select null
275: from ben_asnt_set_rt_f
276: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
277: and asnt_set_rt_id <> nvl(p_asnt_set_rt_id,-1)
278: and p_effective_date between effective_start_date
279: and effective_end_date

Line 653: ben_asnt_set_rt_f b

649: --
650: cursor csr_leg_code is
651: select a.legislation_code
652: from per_business_groups a,
653: ben_asnt_set_rt_f b
654: where b.asnt_set_rt_id = p_asnt_set_rt_id
655: and a.business_group_id = b.business_group_id;
656: --
657: -- Declare local variables