Contract status is not updating when contract employee transfer from contract to non-contract

Hi,

We have a couple of employees who got transferred from contract to permanent role. for them, the HP_CONTRACT_STATUS field from the PS_HP_CNTRACT_LIST table is not updating with 'complete' status. in order to achieve this, I had to run a SQL manually to update the contract status to 'Complete'. otherwise, the CNTPAY01 process runs into ERROR, saying 'Divide by Zero' in PeopleSoft sqr.

UPDATE PS_HP_CNTRACT_LIST SET HP_CONTRACT_STATUS ='C', HP_RECALC_CONTRACT = 'N' WHERE EMPLID = '100XXXXXX';

Is there any delivered process that updates the Contract status when the transfer happens?