APPS.QA_TXN_GRP dependencies on QA_OCCURRENCE_S

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

514: ' last_updated_by, qa_last_updated_by, ' ||
515: ' created_by, qa_created_by ';
516:
517: l_insert_values :=
518: ' VALUES(1, :c1, :c2, :c3, qa_occurrence_s.nextval,' ||
519: ' sysdate, sysdate,' ||
520: ' sysdate, sysdate,' ||
521: ' :c4, :c5,' ||
522: ' :c6, :c7';

Line 995: SELECT qa_occurrence_s.nextval

991: p_collection_id IN NUMBER,
992: p_txn_header_id IN NUMBER) IS
993:
994: CURSOR C1 IS
995: SELECT qa_occurrence_s.nextval
996: FROM DUAL;
997:
998: CURSOR C2(c_collection_id NUMBER) IS
999: SELECT DISTINCT qpt.plan_id