DBA Data[Home] [Help]

APPS.AMS_DMLIFT_PUB dependencies on DUAL

Line 567: FROM dual;

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: ;