DBA Data[Home] [Help]

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