Resolution:
If you have duplicate or unwanted WF templates in your IC database and you want to delete them, run the command 'Delete Job' in Batch Registry. This command removes associated tasks, attributes and other referenced table entries of the WF template as well. You can use the following command in the Batch Registry to delete any of the duplicate or unwanted WF templates from the IC database.

Delete Job [ID]

Note: [ID] is the job ID of the WF template.

Example: Delete Job 0200001700000463005D000100000007;

If you want to delete a particular WF template version, then to find the workflow template for a particular version number, do the following:

Query "select * from jobs where name = <workflow template-name>" from  job table to get job id (template id).
Query "select * from attributes where object_id= <job id>) attribute table to find version for particulare job id (template id).