563: l_dummy NUMBER;
564:
565: CURSOR c_lift_id IS
566: SELECT ams_dm_lift_s.NEXTVAL 567: FROM dual; 568:
569: CURSOR c_id_exists (p_lift_id IN NUMBER) IS
570: SELECT 1
571: FROM dual
Line 571: FROM dual
567: FROM dual;
568:
569: CURSOR c_id_exists (p_lift_id IN NUMBER) IS
570: SELECT 1 571: FROM dual 572: WHERE EXISTS (SELECT 1
573: FROM ams_dm_lift
574: WHERE lift_id = p_lift_id)
575: ;