806: --
807: CURSOR c_seq
808: IS
809: SELECT AHL_SPACE_UNAVAILABLE_B_S.NEXTVAL
810: FROM dual;
811: --
812: CURSOR c_id_exists (x_id IN NUMBER) IS
813: SELECT 1
814: FROM dual
810: FROM dual;
811: --
812: CURSOR c_id_exists (x_id IN NUMBER) IS
813: SELECT 1
814: FROM dual
815: WHERE EXISTS (SELECT 1
816: FROM ahl_space_unavailable_b
817: WHERE space_unavailability_id = x_id);
818: --