SHARE
TWEET

Untitled

tercnem Jun 30th, 2020 836 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. begin;
  2. --insert
  3. CREATE table mstr.m_commission_20200225 AS (
  4.     SELECT * from mstr.m_commission
  5. );
  6.  
  7. INSERT INTO mstr.tt_migrasi_master_commission(session_id, ou_code_alias, product_code, role_name, year_month_start, year_month_end, acc_amount, tindakan_1_amount, tindakan_2_amount, tindakan_3_amount) VALUES
  8. ('sts123_2020022516', '', 'TMIN025', 'DOKTER', '202002', '300012', 0, 12000, 0, 0),
  9. ('sts123_2020022516', '', 'TMIN026', 'DOKTER', '202002', '300012', 0, 16000, 0, 0),
  10. ('sts123_2020022516', '', 'TMIN027', 'DOKTER', '202002', '300012', 0, 12000, 0, 0),
  11. ('sts123_2020022516', '', 'TMIN028', 'DOKTER', '202002', '300012', 0, 16000, 0, 0),
  12. ('sts123_2020022516', '', 'TMCA005', 'DOKTER', '202002', '300012', 0, 40000, 0, 0),
  13. ('sts123_2020022516', '', 'TMCA006', 'DOKTER', '202002', '300012', 0, 45000, 0, 0),
  14. ('sts123_2020022516', '', 'TMIN025', 'NONDOKTER', '202002', '300012', 0, 0, 0, 0),
  15. ('sts123_2020022516', '', 'TMIN026', 'NONDOKTER', '202002', '300012', 0, 0, 0, 0),
  16. ('sts123_2020022516', '', 'TMIN027', 'NONDOKTER', '202002', '300012', 0, 0, 0, 0),
  17. ('sts123_2020022516', '', 'TMIN028', 'NONDOKTER', '202002', '300012', 0, 0, 0, 0),
  18. ('sts123_2020022516', '', 'TMCA005', 'NONDOKTER', '202002', '300012', 0, 0, 0, 5000),
  19. ('sts123_2020022516', '', 'TMCA006', 'NONDOKTER', '202002', '300012', 0, 0, 0, 5000);
  20.  
  21. select f_migrate_master_commission('sts123_2020022516',-2,'20200225150000');
  22.  
  23. end;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top