1106: --
1107: CURSOR c_seq
1108: IS
1109: SELECT AHL_SPACE_ASSIGNMENTS_S.NEXTVAL
1110: FROM dual;
1111: --
1112: CURSOR c_id_exists (x_id IN NUMBER) IS
1113: SELECT 1
1114: FROM dual
1110: FROM dual;
1111: --
1112: CURSOR c_id_exists (x_id IN NUMBER) IS
1113: SELECT 1
1114: FROM dual
1115: WHERE EXISTS (SELECT 1
1116: FROM ahl_space_assignments
1117: WHERE space_assignment_id = x_id);
1118: --