231: FROM dual
232: UNION ALL
233: SELECT x.sub_organization_id AS organization_id
234: FROM per_org_hrchy_summary x,
235: per_org_structure_versions v,
236: per_org_structure_versions currv
237: WHERE v.org_structure_version_id = p_org_structure_version_id AND
238: v.organization_structure_id = currv.organization_structure_id AND
239: (currv.date_to IS NULL OR
232: UNION ALL
233: SELECT x.sub_organization_id AS organization_id
234: FROM per_org_hrchy_summary x,
235: per_org_structure_versions v,
236: per_org_structure_versions currv
237: WHERE v.org_structure_version_id = p_org_structure_version_id AND
238: v.organization_structure_id = currv.organization_structure_id AND
239: (currv.date_to IS NULL OR
240: sysdate BETWEEN currv.date_from AND currv.date_to) AND