249: ***********************************************************/
250: --
251: CURSOR c_get_organization_name (cp_organization_id IN NUMBER) IS
252: SELECT name
253: FROM hr_organization_units
254: WHERE organization_id=cp_organization_id;
255: --
256: /***********************************************************
257: ** CURSORs to get payroll,consolidation set names **