DBA Data[Home] [Help]

APPS.QLTTRAMB dependencies on DUAL

Line 27: FROM dual;

23: item_key number;
24:
25: CURSOR c IS
26: SELECT qa_ss_import_workflow_s.nextval
27: FROM dual;
28: BEGIN
29: OPEN c;
30: FETCH c INTO item_key;
31: CLOSE c;

Line 228: SELECT QA_GROUP_S.NEXTVAL INTO X_GROUP_ID FROM DUAL;

224:
225: -- if this is the first row in a group, fetch a new group id
226:
227: IF (ROW_COUNT = 1) THEN
228: SELECT QA_GROUP_S.NEXTVAL INTO X_GROUP_ID FROM DUAL;
229: END IF;
230:
231: -- assign the current group id to the current row
232: