DBA Data[Home] [Help]

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 996: FROM DUAL;

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
1000: FROM qa_plan_transactions qpt