APPS.OZF_SD_REQUEST_PUB dependencies on HR_OPERATING_UNITS
Line 414: FROM hr_operating_units ou
410: WHERE user_id =p_user_id;
411:
412: CURSOR c_org_id(p_org_id IN NUMBER)IS
413: SELECT ou.organization_id org_id 414: FROM hr_operating_units ou 415: WHERE MO_GLOBAL.check_access(ou.organization_id) = 'Y'
416: AND ou.organization_id =p_org_id;
417:
418: CURSOR c_resource_id (p_user_id IN NUMBER) IS