• Is there a chance to have the data changes (in the employee table) replicated and the have the data changes applied by the SP execution by the subscribers too?

    this is an unnecessary redundancy.