Trending @Accenture; In my current project it showing "Loaned Resource". Will it effect anything for me

No bro, it won't effect anything for you. chill 😎

You can be rolled off from the project after the other employee working on that project that is on leave, comes back. But no worries, you can get the new project.