75: NAME
76: INTO
77: L_NAME
78: FROM
79: HR_ORGANIZATION_UNITS
80: WHERE ORGANIZATION_ID = P_ORG_ID;
81: RETURN (L_NAME);
82: EXCEPTION
83: WHEN OTHERS THEN
178: NAME
179: INTO
180: L_NAME
181: FROM
182: HR_ORGANIZATION_UNITS
183: WHERE ORGANIZATION_ID = P_EMP_OFFICE;
184: RETURN (L_NAME);
185: EXCEPTION
186: WHEN OTHERS THEN