309: -- organization id
310: --------------------------------------------------------------------------+
311: FUNCTION get_id( p_org_name IN VARCHAR2)
312: RETURN NUMBER IS
313: l_organization_id HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE;
314: BEGIN
315:
316: SELECT organization_id INTO l_organization_id
317: FROM HR_ALL_ORGANIZATION_UNITS
313: l_organization_id HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE;
314: BEGIN
315:
316: SELECT organization_id INTO l_organization_id
317: FROM HR_ALL_ORGANIZATION_UNITS
318: WHERE name = p_org_name;
319:
320: RETURN (l_organization_id);
321: END get_id;