text: DROP TABLE IF EXISTS opm.letter;
  DROP TABLE IF EXISTS opm.reference;
  DROP TABLE IF EXISTS opm.payment_statement_print;
  DROP TABLE IF EXISTS opm.batch_daily_payments;
  DROP TABLE IF EXISTS opm.payment_transaction;
  DROP TABLE IF EXISTS opm.mainframe_import CASCADE;
  DROP TABLE IF EXISTS opm.audit_batch;
  DROP TABLE IF EXISTS opm.new_claim_number;
  DROP TABLE IF EXISTS opm.annuitant_list;
  DROP TABLE IF EXISTS opm.time_factor;
  DROP TABLE IF EXISTS opm.contact_info;
  DROP TABLE IF EXISTS opm.interest_suppression;
  DROP TABLE IF EXISTS opm.gl_payment_type;
  DROP TABLE IF EXISTS opm.scm_first_insert;
  DROP TABLE IF EXISTS opm.holiday;
  DROP TABLE IF EXISTS opm.deduction_rate;
  DROP TABLE IF EXISTS opm.interest_grace_period;
  DROP TABLE IF EXISTS opm.gl_code;
  DROP TABLE IF EXISTS opm.claim_without_service;
  DROP TABLE IF EXISTS opm.payment_transaction_note;
  DROP TABLE IF EXISTS opm.payment_move_transaction;
  DROP TABLE IF EXISTS opm.interest_rate;
  DROP TABLE IF EXISTS opm.payment_interest_detail;
  DROP TABLE IF EXISTS opm.adjustment_transaction;
  DROP TABLE IF EXISTS opm.invoice;
  DROP TABLE IF EXISTS opm.a01_print_suppression_case;
  DROP TABLE IF EXISTS opm.user_account_assignment;
  DROP TABLE IF EXISTS opm.payment_refund_link;
  
  
  DROP TABLE IF EXISTS opm.audit_batch_log_id;
  DROP TABLE IF EXISTS opm.all_details;
  DROP TABLE IF EXISTS opm.invoice_data;
  
  
  DROP TABLE IF EXISTS opm.role_permission;
  DROP TABLE IF EXISTS opm.user_permission;
  DROP TABLE IF EXISTS opm.service_credit_preference;
  DROP TABLE IF EXISTS opm.account_confirmation_validation_entry;
  DROP TABLE IF EXISTS opm.payment_reverse;
  DROP TABLE IF EXISTS opm.payment;
  DROP TABLE IF EXISTS opm.payments_applied_order_code;
  DROP TABLE IF EXISTS opm.pay_trans_status_code;
  DROP TABLE IF EXISTS opm.printout;
  DROP TABLE IF EXISTS opm.related_help_items;
  DROP TABLE IF EXISTS opm.help_item;
  DROP TABLE IF EXISTS opm.notification_READBY;
  DROP TABLE IF EXISTS opm.date_calculation_data;
  DROP TABLE IF EXISTS opm.refund_transaction;
  DROP TABLE IF EXISTS opm.audit_parameter_record;
  DROP TABLE IF EXISTS opm.audit_record;
  DROP TABLE IF EXISTS opm.dedeposit;
  DROP TABLE IF EXISTS opm.redeposit;
  DROP TABLE IF EXISTS opm.intermediate_result;
  DROP TABLE IF EXISTS opm.calculation_result_item;
  DROP TABLE IF EXISTS opm.calculation;
  DROP TABLE IF EXISTS opm.calculation_version;
  DROP TABLE IF EXISTS opm.calculation_result;
  DROP TABLE IF EXISTS opm.deduction_calculation_detail;
  DROP TABLE IF EXISTS opm.summary_data;
  DROP TABLE IF EXISTS opm.billing;
  DROP TABLE IF EXISTS opm.account_note;
  DROP TABLE IF EXISTS opm.account;
  DROP TABLE IF EXISTS opm.account_confirmation_validation;
  DROP TABLE IF EXISTS opm.billing_summary;
  DROP TABLE IF EXISTS opm.account_holder;
  DROP TABLE IF EXISTS opm.address;
  DROP TABLE IF EXISTS opm.error;
  DROP TABLE IF EXISTS opm.info;
  DROP TABLE IF EXISTS opm.notification;
  DROP TABLE IF EXISTS opm.app_user;
  
  DROP TABLE IF EXISTS opm.batch_daily_payments_history;
  DROP TABLE IF EXISTS opm.audit_batch_history;
  DROP TABLE IF EXISTS opm.new_claim_number_history;
  DROP TABLE IF EXISTS opm.annuitant_list_history;
  DROP TABLE IF EXISTS opm.time_factor_history;
  DROP TABLE IF EXISTS opm.contact_info_history;
  DROP TABLE IF EXISTS opm.interest_suppression_history;
  DROP TABLE IF EXISTS opm.gl_payment_type_history;
  DROP TABLE IF EXISTS opm.scm_first_insert_history;
  DROP TABLE IF EXISTS opm.holiday_history;
  DROP TABLE IF EXISTS opm.deduction_rate_history;
  DROP TABLE IF EXISTS opm.interest_grace_period_history;
  DROP TABLE IF EXISTS opm.gl_code_history;
  DROP TABLE IF EXISTS opm.claim_without_service_history;
  DROP TABLE IF EXISTS opm.payment_transaction_note_history;
  DROP TABLE IF EXISTS opm.payment_move_transaction_history;
  DROP TABLE IF EXISTS opm.interest_rate_history;
  DROP TABLE IF EXISTS opm.payment_interest_detail_history;
  DROP TABLE IF EXISTS opm.adjustment_transaction_history;
  DROP TABLE IF EXISTS opm.invoice_history;
  DROP TABLE IF EXISTS opm.a01_print_suppression_case_history;
  DROP TABLE IF EXISTS opm.user_account_assignment_history;
  DROP TABLE IF EXISTS opm.payment_refund_link_history;
  DROP TABLE IF EXISTS opm.payments_applied_order_code_history;
  
  DROP TABLE IF EXISTS opm.service_credit_preference_history;
  DROP TABLE IF EXISTS opm.account_confirmation_validation_entry_history;
  DROP TABLE IF EXISTS opm.account_confirmation_validation_history;
  DROP TABLE IF EXISTS opm.payment_reverse_history;
  DROP TABLE IF EXISTS opm.payment_history;
  DROP TABLE IF EXISTS opm.pay_trans_status_code_history;
  DROP TABLE IF EXISTS opm.notification_READBY_history;
  DROP TABLE IF EXISTS opm.refund_transaction_history;
  DROP TABLE IF EXISTS opm.summary_data_history;
  DROP TABLE IF EXISTS opm.dedeposit_history;
  DROP TABLE IF EXISTS opm.redeposit_history;
  DROP TABLE IF EXISTS opm.calculation_result_item_history;
  DROP TABLE IF EXISTS opm.calculation_result_history;
  DROP TABLE IF EXISTS opm.calculation_history;
  DROP TABLE IF EXISTS opm.calculation_version_history;
  DROP TABLE IF EXISTS opm.billing_history;
  DROP TABLE IF EXISTS opm.billing_summary_history;
  DROP TABLE IF EXISTS opm.account_note_history;
  DROP TABLE IF EXISTS opm.address_history;
  DROP TABLE IF EXISTS opm.account_history;
  DROP TABLE IF EXISTS opm.account_holder_history;
  DROP TABLE IF EXISTS opm.error_history;
  DROP TABLE IF EXISTS opm.info_history;
  DROP TABLE IF EXISTS opm.notification_history;
  DROP TABLE IF EXISTS opm.app_user_history;
  
  DROP TABLE IF EXISTS opm.change_trans_field_number_code;
  DROP TABLE IF EXISTS opm.pay_code;
  DROP TABLE IF EXISTS opm.payment_applied_order;
  DROP TABLE IF EXISTS opm.agency_code;
  DROP TABLE IF EXISTS opm.calculation_status;
  DROP TABLE IF EXISTS opm.transfer_type;
  DROP TABLE IF EXISTS opm.user_status;
  DROP TABLE IF EXISTS opm.claim_officer;
  DROP TABLE IF EXISTS opm.payment_status;
  DROP TABLE IF EXISTS opm.application_designation;
  DROP TABLE IF EXISTS opm.payment_reversal_reason;
  DROP TABLE IF EXISTS opm.pay_type;
  DROP TABLE IF EXISTS opm.appointment_type;
  DROP TABLE IF EXISTS opm.role;
  DROP TABLE IF EXISTS opm.service_type;
  DROP TABLE IF EXISTS opm.retirement_type;
  DROP TABLE IF EXISTS opm.account_status;
  DROP TABLE IF EXISTS opm.country;
  DROP TABLE IF EXISTS opm.state;
  DROP TABLE IF EXISTS opm.period_type;
  DROP TABLE IF EXISTS opm.suffix;
  DROP TABLE IF EXISTS opm.form_type;
  DROP TABLE IF EXISTS opm.payment_appliance;
  DROP SEQUENCE IF EXISTS opm.claim_number;
  
  DROP FUNCTION IF EXISTS opm.batch_daily_payments_func();
  DROP FUNCTION IF EXISTS opm.audit_batch_func();
  DROP FUNCTION IF EXISTS opm.new_claim_number_func();
  DROP FUNCTION IF EXISTS opm.annuitant_list_func();
  DROP FUNCTION IF EXISTS opm.time_factor_func();
  DROP FUNCTION IF EXISTS opm.contact_info_func();
  DROP FUNCTION IF EXISTS opm.interest_suppression_func();
  DROP FUNCTION IF EXISTS opm.gl_payment_type_func();
  DROP FUNCTION IF EXISTS opm.scm_first_insert_func();
  DROP FUNCTION IF EXISTS opm.holiday_func();
  DROP FUNCTION IF EXISTS opm.deduction_rate_func();
  DROP FUNCTION IF EXISTS opm.interest_grace_period_func();
  DROP FUNCTION IF EXISTS opm.gl_code_func();
  DROP FUNCTION IF EXISTS opm.claim_without_service_func();
  DROP FUNCTION IF EXISTS opm.payment_transaction_note_func();
  DROP FUNCTION IF EXISTS opm.payment_move_transaction_func();
  DROP FUNCTION IF EXISTS opm.interest_rate_func();
  DROP FUNCTION IF EXISTS opm.payment_interest_detail_func();
  DROP FUNCTION IF EXISTS opm.adjustment_transaction_func();
  DROP FUNCTION IF EXISTS opm.invoice_func();
  DROP FUNCTION IF EXISTS opm.a01_print_suppression_case_func();
  DROP FUNCTION IF EXISTS opm.user_account_assignment_func();
  DROP FUNCTION IF EXISTS opm.payment_refund_link_func();
  DROP FUNCTION IF EXISTS opm.payments_applied_order_code_func();
  
  DROP FUNCTION IF EXISTS opm.service_credit_preference_func();
  DROP FUNCTION IF EXISTS opm.account_confirmation_validation_entry_func();
  DROP FUNCTION IF EXISTS opm.account_confirmation_validation_func();
  DROP FUNCTION IF EXISTS opm.payment_reverse_func();
  DROP FUNCTION IF EXISTS opm.payment_func();
  DROP FUNCTION IF EXISTS opm.pay_trans_status_code_func();
  DROP FUNCTION IF EXISTS opm.notification_READBY_func();
  DROP FUNCTION IF EXISTS opm.refund_transaction_func();
  DROP FUNCTION IF EXISTS opm.summary_data_func();
  DROP FUNCTION IF EXISTS opm.dedeposit_func();
  DROP FUNCTION IF EXISTS opm.redeposit_func();
  DROP FUNCTION IF EXISTS opm.calculation_result_item_func();
  DROP FUNCTION IF EXISTS opm.calculation_result_func();
  DROP FUNCTION IF EXISTS opm.calculation_func();
  DROP FUNCTION IF EXISTS opm.calculation_version_func();
  DROP FUNCTION IF EXISTS opm.billing_func();
  DROP FUNCTION IF EXISTS opm.billing_summary_func();
  DROP FUNCTION IF EXISTS opm.account_note_func();
  DROP FUNCTION IF EXISTS opm.address_func();
  DROP FUNCTION IF EXISTS opm.account_func();
  DROP FUNCTION IF EXISTS opm.account_holder_func();
  DROP FUNCTION IF EXISTS opm.error_func();
  DROP FUNCTION IF EXISTS opm.info_func();
  DROP FUNCTION IF EXISTS opm.notification_func();
  DROP FUNCTION IF EXISTS opm.app_user_func();
  
  DROP TABLE IF EXISTS opm.report_generation_data;
  DROP TABLE IF EXISTS opm.report_generation_data_history;
  DROP FUNCTION IF EXISTS opm.report_generation_data_func();
  
  DROP SCHEMA opm CASCADE;
  