I couldn't make your code work.

so I had to adapt it.

Also the table Code_Charge_Credit is missing, so I removed it.

CREATE TABLE dbo.CHARGECREDIT( PEOPLE_ORG_CODE_ID NVARCHAR(10) NOT NULL, 
...

many times it is due to the fact that your query is running against the MyDBName database and so there is an open connection.