APPS.OZF_SD_REQUEST_PUB dependencies on HR_OPERATING_UNITS
Line 582: FROM hr_operating_units ou
578: WHERE user_id =p_user_id;
579:
580: CURSOR c_org_id(p_org_id IN NUMBER)IS
581: SELECT ou.organization_id org_id 582: FROM hr_operating_units ou 583: WHERE MO_GLOBAL.check_access(ou.organization_id) = 'Y'
584: AND ou.organization_id =p_org_id;
585:
586: CURSOR c_resource_id (p_user_id IN NUMBER) IS