762: --
763: CURSOR c_seq
764: IS
765: SELECT AHL_SPACE_ASSIGNMENTS_S.NEXTVAL
766: FROM dual;
767: --
768: CURSOR c_id_exists (x_id IN NUMBER) IS
769: SELECT 1
770: FROM dual
766: FROM dual;
767: --
768: CURSOR c_id_exists (x_id IN NUMBER) IS
769: SELECT 1
770: FROM dual
771: WHERE EXISTS (SELECT 1
772: FROM ahl_space_assignments
773: WHERE space_assignment_id = x_id);
774: --