[Home] [Help]
719: p_collection_id IN NUMBER
720: ) IS
721: PRAGMA autonomous_transaction;
722:
723: l_occurrences dbms_sql.number_table;
724: l_plans dbms_sql.number_table;
725:
726: CURSOR C IS
727: SELECT occurrence, plan_id
720: ) IS
721: PRAGMA autonomous_transaction;
722:
723: l_occurrences dbms_sql.number_table;
724: l_plans dbms_sql.number_table;
725:
726: CURSOR C IS
727: SELECT occurrence, plan_id
728: FROM qa_results