Line 415: WHERE MO_GLOBAL.check_access(ou.organization_id) = 'Y'
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
419: SELECT resource_id