Let’s say a user added two leaves, as shown in the figure below:
You can find leaves added to users from table TB_LEAVE.
You can find which type these leaves are of from table TB_LEAVE_ITEM. Compare the column nType in both tables.
You can find who have these leaves from table TB_TA_USER. You can use columns nTAIdn and nUserTAIdn as a matching key.