BEGIN

INSERT INTO PAT_AJS.dbo.AJS_Client_Invoices

SELECT IL.INVOICE_ID, IH.Invocie_DATE,

IH.Case_ID,IH.Actor_ID,IL.Invoice_Line_Text ,IL.Invoice_Amount,B_L_SEQ_NUMBER,B_L_AMOUNT,BL.WORK_CODE_ID

FROM INVOICE_LINE IL, INVOICE_HEADER IH, BUDGET_LINE BL

WHERE IH.Invoice_ID = IL.Invoice_ID

AND IL.INVOICE_ID = (SELECT MAX(invoice_id)

FROM INVOICE_HEADER

WHERE INVOICE_ID > 9990000

AND INVOICE_ID LIKE '1%')

AND B_L_INVOICE_NUMBER = IH.INVOICE_ID

END