APPS.AMS_SCORERESULT_PVT dependencies on DUAL

Line 124: FROM dual;

120: l_dummy NUMBER;
121:
122: CURSOR c_id IS
123: SELECT AMS_DM_SCORE_RESULTS_s.NEXTVAL
124: FROM dual;
125:
126: CURSOR c_id_exists (l_id IN NUMBER) IS
127: SELECT 1 FROM dual
128: WHERE EXISTS (SELECT 1 FROM AMS_DM_SCORE_RESULTS

Line 127: SELECT 1 FROM dual

123: SELECT AMS_DM_SCORE_RESULTS_s.NEXTVAL
124: FROM dual;
125:
126: CURSOR c_id_exists (l_id IN NUMBER) IS
127: SELECT 1 FROM dual
128: WHERE EXISTS (SELECT 1 FROM AMS_DM_SCORE_RESULTS
129: WHERE SCORE_RESULT_ID = l_id);
130:
131: BEGIN

Line 1666: FROM dual;

1662: L_SEEDED_ID_THRESHOLD CONSTANT NUMBER := 10000;
1663:
1664: CURSOR c_scoreListId IS
1665: SELECT AMS_DM_SCORE_LISTS_S.NEXTVAL
1666: FROM dual;
1667: l_insertSql VARCHAR2(1000);
1668: l_scoreListId NUMBER;
1669:
1670: BEGIN