APPS.QA_TXN_GRP dependencies on QA_OCCURRENCE_S

Line 553: ' VALUES(1, :c1, :c2, :c3, qa_occurrence_s.nextval,' ||

549: ' last_updated_by, qa_last_updated_by, ' ||
550: ' created_by, qa_created_by ';
551:
552: l_insert_values :=
553: ' VALUES(1, :c1, :c2, :c3, qa_occurrence_s.nextval,' ||
554: ' sysdate, sysdate,' ||
555: ' sysdate, sysdate,' ||
556: ' :c4, :c5,' ||
557: ' :c6, :c7';

Line 1030: SELECT qa_occurrence_s.nextval

1026: p_collection_id IN NUMBER,
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