Move hr-payroll tables

-- empty seed data
delete from PXRCALC;
delete from PXREXEM;
delete from PXRFSTA;
delete from PXRGRAD;
delete from PXRADDS;
delete from PXRTXCD;
delete from NBRRJQE;
delete from NBRBJQE;
delete from NTRRQUE;
delete from NTRBQUE;
delete from PTRBDPG;
delete from PTRJCRE;
delete from PTREHOL;
delete from PTRJBLN;
delete from NBBPOSN;
delete from NTRPCLS;
delete from NTRFELD;
delete from PTRUSER;
delete from NTRSALA;
delete from NTRSALB;
delete from NTRSGRP;
delete from PTRBDFQ;
delete from PTRGTAX;
delete from PTRCOVR;
delete from PTRPREM;
delete from PTRLIFI;
delete from PTRECBC;
delete from PTRECLC;
delete from PTREERN;
delete from PTRECLS;
delete from PTRBREL;
delete from PTRDFPR;
delete from PTRBCDN;
delete from PTRBCAT;
delete from PTRBDLD;
delete from PTRBDXE;
delete from PTRBDXD;
delete from PTRBDID;
delete from PTRBDCG;
delete from PTRBDLG;
delete from PTRBDAS;
delete from PTRBDPD;
delete from PTRBDCA;
delete from PTRLVPR;
delete from PTRLVAC;
delete from PTRLVAS;
delete from PTRECLD;
delete from PTREARN;
delete from PTRLEAV;
delete from PTRTREA;
delete from PTRLREA;
delete from PTRCALN;
delete from PTRPICT;
delete from PEREEO6;
delete from PTREMPR;
delete from PTRINST;
delete from NTRINST;
delete from PTVLCAT;

commit;

-- copy tables over DB link
create database link PDAY
  connect to username identified by password
  using 'PDAY';
  

insert into NTRINST select * from NTRINST@pday;
insert into PTRINST select * from PTRINST@pday;
insert into PEREEO6 select * from PEREEO6@pday;
insert into PTREMPR select * from PTREMPR@pday;
insert into PTRPICT select * from PTRPICT@pday;
insert into PTRCALN select * from PTRCALN@pday;
insert into PTRLREA select * from PTRLREA@pday;
insert into PTRTREA select * from PTRTREA@pday;
insert into PTRLEAV select * from PTRLEAV@pday;
insert into PTREARN select * from PTREARN@pday;
insert into PTRECLD select * from PTRECLD@pday;
insert into PTVLCAT select * from PTVLCAT@pday; -- 
insert into PTRLVAS select * from PTRLVAS@pday;
insert into PTRLVAC select * from PTRLVAC@pday;
insert into PTRLVPR select * from PTRLVPR@pday;
insert into PTRBDCA select * from PTRBDCA@pday;
insert into PTRBDPD select * from PTRBDPD@pday;
insert into PTRBDAS select * from PTRBDAS@pday;
insert into PTRBDLG select * from PTRBDLG@pday;
insert into PTRBDCG select * from PTRBDCG@pday;
insert into PTRBDID select * from PTRBDID@pday;
insert into PTRBDXD select * from PTRBDXD@pday;
insert into PTRBDXE select * from PTRBDXE@pday;
insert into PTRBDLD select * from PTRBDLD@pday;
insert into PTRBCAT select * from PTRBCAT@pday;
insert into PTRBCDN select * from PTRBCDN@pday;
insert into PTRDFPR select * from PTRDFPR@pday;
insert into PTRBREL select * from PTRBREL@pday;
insert into PTRECLS select * from PTRECLS@pday;
insert into PTREERN select * from PTREERN@pday;
insert into PTRECLC select * from PTRECLC@pday;
insert into PTRECBC select * from PTRECBC@pday;
insert into PTRLIFI select * from PTRLIFI@pday;
insert into PTRPREM select * from PTRPREM@pday;
insert into PTRCOVR select * from PTRCOVR@pday;
insert into PTRGTAX select * from PTRGTAX@pday;
insert into PTRBDFQ select * from PTRBDFQ@pday;
insert into NTRSGRP select * from NTRSGRP@pday;
insert into NTRSALB select * from NTRSALB@pday;
insert into NTRSALA select * from NTRSALA@pday;
insert into PTRUSER select * from PTRUSER@pday;
insert into NTRFELD select * from NTRFELD@pday;
insert into NTRPCLS select * from NTRPCLS@pday;
insert into NBBPOSN select * from NBBPOSN@pday;
insert into PTRJBLN select * from PTRJBLN@pday;
insert into PTREHOL select * from PTREHOL@pday;
insert into PTRJCRE select * from PTRJCRE@pday;
insert into PTRBDPG select * from PTRBDPG@pday;
insert into NTRBQUE select * from NTRBQUE@pday;
insert into NTRRQUE select * from NTRRQUE@pday;
insert into NBRBJQE select * from NBRBJQE@pday;
insert into NBRRJQE select * from NBRRJQE@pday;
insert into PXRTXCD select * from PXRTXCD@pday;
insert into PXRADDS select * from PXRADDS@pday;
insert into PXRGRAD select * from PXRGRAD@pday;
insert into PXRFSTA select * from PXRFSTA@pday;
insert into PXREXEM select * from PXREXEM@pday;
insert into PXRCALC select * from PXRCALC@pday;

commit;

drop database link PDAY;