463: SELECT 'Y'
464: FROM SYS.dual
465: WHERE EXISTS (
466: SELECT '1'
467: FROM hr_organization_units hou, hr_organization_information hoi
468: WHERE (p_org_id <> hoi.organization_id)
469: AND hou.organization_id = hoi.organization_id
470: AND hou.business_group_id IN (
471: SELECT o3.organization_id