DBA Data[Home] [Help]

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