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
181: NAME
182: INTO
183: L_NAME
184: FROM
185: HR_ORGANIZATION_UNITS
186: WHERE ORGANIZATION_ID = P_EMP_OFFICE;
187: RETURN (L_NAME);
188: EXCEPTION
189: WHEN OTHERS THEN