Automatic updation of EMISPending for loan

I Have created using DAL this is the query wat i created..
INSERT [table] EXECUTE ('SELECT e.emp_id,
(CASE WHEN l.emis_pending > 0 THEN l.loan_id else 0 end) as loan_id,
@date,
(CASE WHEN l.emis_pending > 0 THEN (l.principal_amt/l.tot_emis) else 0 end) as emi_amt
FROM earning e, loan l
WHERE (e.emp_id = lm.emp_id) AND (lm.emis_pending > 0)')
This is for inserting in loan transaction..
And for emi pending i just created this much:
SELECT *
FROM table
WHERE emp_id = @emp_id AND emis_pending > 0
i dont know how to proceed further....