Stored Procedure executing multiple statements

I'm working on the following stored procedure but may need a little help.. Any help is appreciated.

My stored procedure is executed from a trigger and receives a parameter (QuoteID)

In my stored procedure

1. I must select the following data to prepare for an email that will be sent

SELECT     QL.QuoteID, 
           QL.PartID, 
           QL.PartDesc, 
           QL.OnticPartID, 
           QL.CustPartID, 
           QL.Qty, 
           QL.LicenseCode, 
           QL.TotalPrice, 
           QL.UnitPrice, 
           T.QuoteDate, 
           T.Buyer, 
           T.SalesRep, 
           T.PlmName, 
           T.PlmEmail

FROM       QLINES QL INNER JOIN
                      QRT T ON QLINES.QuoteID = QRT.QuoteID

Where QL.QuoteID = @QuoteID

1. Select the following data from another database based on the Part Numbers in the first set of data in the previous statement.

FOR EACH PART do the following

SELECT TOP 1 Q.ID AS QUOTE_ID 
      ,Q.QUOTE_DATE AS QUOTE_DATE 
      ,QL.LINE_NO AS QUOTE_LINE_NO 
      ,QP.QTY AS QUOTE_QTY 
      ,QP.UNIT_PRICE AS QUOTE_PRICE 
      FROM    QLINE QL 
LEFT JOIN QUOTE_PRICE QP 
       ON QL.QUOTE_ID = QP.QUOTE_ID 
     AND QL.LINE_NO = QP.QUOTE_LINE_NO 
LEFT JOIN QUOTE Q 
       ON QL.QUOTE_ID = Q.ID 
 WHERE QL.PART_ID = @
  AND LEFT(QL.QUOTE_ID,1) = 'E' " 
ORDER BY Q.QUOTE_DATE DESC

1. I will need to put the first of each PART, FIRST SET QTY, FIRST SET LicenseCode , FIRST SET PLMname, FIRST SET PLMemail, UNIT_Price in a temp table.
2. Multiply the QTY by Unit Price for each part.

3. In the last step, I will evaluate if the total of each part is greater than or equal to an amount in another table where LicenseCode=LicenseCode and PLMname = PLMname

4. If the total is greater than the amount in the other table, Send an email to PLMemail