12: org.name
13: INTO o_business_group_id,
14: o_business_group_name
15: FROM igw_implementations imp,
16: hr_organization_units org
17: WHERE org.organization_id = imp.business_group_id;
18:
19: EXCEPTION
20:
284: BEGIN
285:
286: SELECT name
287: INTO v_top_parent_org_name
288: FROM hr_organization_units
289: WHERE organization_id = v_curr_organization_id;
290:
291: EXCEPTION
292: WHEN NO_DATA_FOUND or TOO_MANY_ROWS THEN