33:
34: if p_organization_id is not NULL then
35:
36: select substr(name, 1, 60) into org_name from 37: hr_organization_units 38: where organization_id = p_organization_id;
39: end if;
40: C_org_name := org_name;
41: if ( get_company_name <> TRUE ) then