APPS.BEN_OUR_BUS dependencies on BEN_ORG_UNIT_RT_F

Line 253: from ben_org_unit_rt_f

249: l_exists varchar2(1);
250: --
251: cursor c_dup is
252: select null
253: from ben_org_unit_rt_f
254: where organization_id = p_organization_id
255: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
256: and org_unit_rt_id <> nvl(p_org_unit_rt_id,hr_api.g_number)
257: and business_group_id + 0 = p_business_group_id

Line 334: from ben_org_unit_rt_f

330: is
331: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
332: l_dummy char(1);
333: cursor c1 is select null
334: from ben_org_unit_rt_f
335: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
336: -- changed against bug: 5113011
337: and org_unit_rt_id <> nvl(p_org_unit_rt_id,-1)
338: -- and organization_id <> nvl(p_organization_id,-1)

Line 731: ben_org_unit_rt_f b

727: --
728: cursor csr_leg_code is
729: select a.legislation_code
730: from per_business_groups a,
731: ben_org_unit_rt_f b
732: where b.org_unit_rt_id = p_org_unit_rt_id
733: and a.business_group_id = b.business_group_id;
734: --
735: -- Declare local variables