DBA Data[Home] [Help]

APPS.QA_RESULTS_PKG dependencies on DUAL

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

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