Sanitize global payroll tables

update_gp_tables.sql

UPDATE PS_GP_RSLT_ACUM SET CALC_RSLT_VAL = 0, CALC_VAL = 0
/
UPDATE PS_GP_RSLT_DELTA SET CALC_DELTA_VAL = 0,UNIT_DELTA_VAL = 0, BASE_DELTA_VAL = 0
/
UPDATE PS_GP_RSLT_ERN_DED SET CALC_RSLT_VAL = 0, BASE_RSLT_VAL = 0, RATE_RSLT_VAL = 0, UNIT_RSLT_VAL = 0, RSLT_XFER_VAL = 0
/
UPDATE PS_GP_RSLT_PIN SET CALC_RSLT_VAL = 0
/
UPDATE PS_GP_RSLT_PI_DATA SET GP_AMT = 0, GP_PCT = 0, GP_BASE = 0, GP_UNIT = 0
/
UPDATE PS_GP_PI_GEN_REF SET BNDL_TOTAL = 0
/
UPDATE PS_GP_RSLT_PI_SOVR SET SOVR_VAL_NUM = 0
/
UPDATE PS_GP_PYE_SEG_STAT SET PIN_NET_VAL = 0, PIN_GROSS_VAL = 0
/
UPDATE PS_GP_PAYMENT SET GP_PMT_AMT = 0
/
UPDATE PS_GP_ACM_USER_ADJ SET USER_ADJ_AMT = 0
/
UPDATE PS_GP_GL_DATA SET CALC_RSLT_VAL = 0
/
UPDATE PS_GP_PI_MNL_DATA SET GP_AMT = 1 WHERE GP_AMT <> 0
/
UPDATE PS_GP_PI_MNL_DATA SET GP_PCT = 1 WHERE GP_PCT <> 0
/
UPDATE PS_GP_PI_MNL_DATA SET GP_BASE = 1 WHERE GP_BASE <> 0
/
UPDATE PS_GP_PI_MNL_DATA SET GP_UNIT = 1 WHERE GP_UNIT <> 0
/
UPDATE PS_GP_PI_MNL_DATA SET GP_RATE = 1 WHERE GP_RATE <> 0
/
UPDATE PS_GP_PYE_OVRD SET GP_AMT = 0, GP_PCT = 0, GP_BASE = 0, GP_UNIT = 0
/
UPDATE PS_PYE_BANKACCT SET BANK_CD = '111', ACCOUNT_EC_ID = '111111111111' where COUNTRY_CD = 'ABC'
/