49: *==========================================================================*/
50: FUNCTION Get_OU_NAME( p_org_id IN NUMBER)
51: RETURN VARCHAR2 IS
52:
53: l_ou_name hr_all_organization_units.name%TYPE;
54:
55: BEGIN
56: SELECT name
57: INTO l_ou_name
54:
55: BEGIN
56: SELECT name
57: INTO l_ou_name
58: FROM hr_all_organization_units
59: WHERE organization_id = p_org_id;
60:
61: RETURN l_ou_name;
62: