26: --------------------------------------------------------------
27: P_ORGANIZATION_ID IN NUMBER)
28: RETURN VARCHAR2
29: IS
30: l_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
31: CURSOR cur_org_name IS
32: select tl.name
33: from hr_all_organization_units_tl tl,
34: hr_all_organization_units hou
29: IS
30: l_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
31: CURSOR cur_org_name IS
32: select tl.name
33: from hr_all_organization_units_tl tl,
34: hr_all_organization_units hou
35: where hou.organization_id=p_organization_id
36: and tl.organization_id=hou.organization_id
37: and tl.language=userenv('LANG');