159: --
160: -- ------------------------ return_business_group_id -------------------------
161: --
162: Function return_business_group_id
163: (p_name in per_organization_units.name%TYPE)
164: Return per_organization_units.business_group_id%TYPE Is
165: --
166: l_business_group_id per_organization_units.business_group_id%TYPE;
167: l_proc varchar2(72) := hr_api.g_package||'return_business_group_id';
160: -- ------------------------ return_business_group_id -------------------------
161: --
162: Function return_business_group_id
163: (p_name in per_organization_units.name%TYPE)
164: Return per_organization_units.business_group_id%TYPE Is
165: --
166: l_business_group_id per_organization_units.business_group_id%TYPE;
167: l_proc varchar2(72) := hr_api.g_package||'return_business_group_id';
168: --
162: Function return_business_group_id
163: (p_name in per_organization_units.name%TYPE)
164: Return per_organization_units.business_group_id%TYPE Is
165: --
166: l_business_group_id per_organization_units.business_group_id%TYPE;
167: l_proc varchar2(72) := hr_api.g_package||'return_business_group_id';
168: --
169: -- Note: This cursor statement should not require a distinct, as
170: -- business group names should be unique. It has been