DBA Data[Home] [Help]

APPS.AMS_DMLIFT_PVT dependencies on DUAL

Line 196: FROM dual;

192: l_dummy NUMBER;
193:
194: CURSOR c_id IS
195: SELECT AMS_DM_LIFT_s.NEXTVAL
196: FROM dual;
197:
198: CURSOR c_id_exists (l_id IN NUMBER) IS
199: SELECT 1 FROM dual
200: WHERE EXISTS (SELECT 1 FROM AMS_DM_LIFT

Line 199: SELECT 1 FROM dual

195: SELECT AMS_DM_LIFT_s.NEXTVAL
196: FROM dual;
197:
198: CURSOR c_id_exists (l_id IN NUMBER) IS
199: SELECT 1 FROM dual
200: WHERE EXISTS (SELECT 1 FROM AMS_DM_LIFT
201: WHERE LIFT_ID = l_id);
202:
203: BEGIN