 AND   ac.concept_code NOT IN (SELECT pack_concept_code FROM pc_stage);
 COMMIT;
 
---29.2 AMIS
+--27.2 AMIS
 INSERT /*+ APPEND */ INTO pc_stage
 (
   pack_concept_code,

AND   ac.concept_code NOT IN (SELECT pack_concept_code FROM pc_stage);
COMMIT;

--30 fix inert ingredients in contraceptive packs
UPDATE pc_stage
   SET amount = 7
 WHERE (pack_concept_code, drug_concept_code) IN (SELECT p.pack_concept_code, p.drug_concept_code

                              AND denominator_unit = 'mL');
COMMIT;

--18.1 Remove those with less than 0.05 ml in denominator
DELETE FROM ds_stage
      WHERE drug_concept_code IN (SELECT drug_concept_code
                                    FROM ds_stage
