DBA Data[Home] [Help]

APPS.QA_RESULTS_PKG dependencies on DUAL

Line 274: CURSOR C2 IS SELECT qa_occurrence_s.nextval FROM dual;

270: CURSOR C IS SELECT rowid FROM QA_RESULTS
271: WHERE plan_id = x_plan_id
272: AND collection_id = X_Collection_Id
273: and occurrence = X_Occurrence;
274: CURSOR C2 IS SELECT qa_occurrence_s.nextval FROM dual;
275: BEGIN
276: if (X_Occurrence is NULL) then
277: OPEN C2;
278: FETCH C2 INTO X_Occurrence;