5059: BEGIN
5060: /*
5061: SELECT 'X'
5062: INTO l_dummy
5063: FROM hr_operating_units hr
5064: WHERE hr.organization_id = p_org_id
5065: AND MO_GLOBAL.check_access(hr.organization_id) = 'Y';
5066: */
5067: l_dummy := MO_GLOBAL.check_access(p_org_id);
5085: BEGIN
5086: IF p_org_id IS NOT NULL THEN
5087: select name
5088: into l_operating_unit
5089: from hr_operating_units
5090: where organization_id = p_org_id;
5091: END IF;
5092: return l_operating_unit;
5093: EXCEPTION