APPS.QA_TXN_GRP dependencies on DUAL

Line 130: SELECT qa_collection_id_s.nextval INTO l_coll_id FROM dual;

126:
127: l_coll_id NUMBER;
128:
129: BEGIN
130: SELECT qa_collection_id_s.nextval INTO l_coll_id FROM dual;
131: RETURN l_coll_id;
132: END get_collection_id;
133:
134: ---------------------------------------------------

Line 1031: FROM DUAL;

1027: p_txn_header_id IN NUMBER) IS
1028:
1029: CURSOR C1 IS
1030: SELECT qa_occurrence_s.nextval
1031: FROM DUAL;
1032:
1033: CURSOR C2(c_collection_id NUMBER) IS
1034: SELECT DISTINCT qpt.plan_id
1035: FROM qa_plan_transactions qpt