APPS.AMS_LIST_QUERY_PVT dependencies on DUAL

Line 58: FROM dual;

54: l_dummy NUMBER;
55:
56: CURSOR c_id IS
57: SELECT AMS_LIST_QUERIES_ALL_s.NEXTVAL
58: FROM dual;
59:
60: CURSOR c_id_exists (l_id IN NUMBER) IS
61: SELECT 1 FROM dual
62: WHERE EXISTS (SELECT 1 FROM AMS_LIST_QUERIES_ALL

Line 61: SELECT 1 FROM dual

57: SELECT AMS_LIST_QUERIES_ALL_s.NEXTVAL
58: FROM dual;
59:
60: CURSOR c_id_exists (l_id IN NUMBER) IS
61: SELECT 1 FROM dual
62: WHERE EXISTS (SELECT 1 FROM AMS_LIST_QUERIES_ALL
63: WHERE LIST_QUERY_ID = l_id);
64:
65: BEGIN