637:
638:
639:
640: DELETE FROM PA_BIS_PRJ_BY_PRD_DRILLS;
641: DELETE FROM PA_BIS_PRJ_TO_DATE_DRILLS;
642: DELETE FROM PA_BIS_TO_DATE_DRILLS;
643: DELETE FROM PA_BIS_TOTALS_BY_PRD;
644: DELETE FROM PA_BIS_TOTALS_TO_DATE;
645:
844:
845: END LOOP;
846:
847:
848: INSERT INTO PA_BIS_PRJ_TO_DATE_DRILLS
849: (
850: drilldown_type
851: , amount_type_code
852: , drilldown_key1
1003: COMMIT;
1004:
1005:
1006:
1007: INSERT INTO PA_BIS_PRJ_TO_DATE_DRILLS
1008: (
1009: drilldown_type
1010: , amount_type_code
1011: , drilldown_key1