Thanks Crystal for pointing me in the right direction.
Here's the code that made it work for anyone who is interested.
Any suggestions on how to make it more efficient are welcome.
<cfquery name="ProductPrices" datasource="secret">
SELECT quantity, customer_price
FROM price_list
WHERE product_id = #GetProduct.product_id#
ORDER BY quantity
</cfquery>
<cfquery name="GetPricingUnattained" datasource="secret">
SELECT quantity AS GreaterThan, customer_price
FROM price_list
WHERE product_id = #GetProduct.product_id#
AND quantity > (SELECT SUM(quantity) AS CurrentQty
FROM orders
WHERE bpid = #URL.bpid#
AND (order_status = 'hold' OR order_status = 'approval_2' OR order_status = 'prep'))
ORDER BY quantity
</cfquery>
<cfquery name="GetPricingAttained" datasource="secret">
SELECT quantity AS LessThan, customer_price
FROM price_list
WHERE product_id = #GetProduct.product_id#
AND quantity <= (SELECT SUM(quantity) AS CurrentQty
FROM orders
WHERE bpid = #URL.bpid#
AND (order_status = 'hold' OR order_status = 'approval_2' OR order_status = 'prep'))
ORDER BY quantity
</cfquery>
<cfset Display = "start">
<!--- LessThanExists Current=middle GreaterThanExists --->
<cfif GetPricingUnattained.RecordCount NEQ "0" AND GetPricingAttained.RecordCount NEQ "0">
<cfoutput query="GetPricingAttained">
<cfif GetPricingAttained.CurrentRow EQ "#GetPricingAttained.RecordCount#">
<cfset CurrentPrice = "#customer_price#">
<cfset Display = "middle">
</cfif>
</cfoutput>
<!--- LessThanExists Current=last GreaterThanExistsNOT --->
<cfelseif GetPricingUnattained.RecordCount EQ "0" AND GetPricingAttained.RecordCount NEQ "0">
<cfoutput query="GetPricingAttained">
<cfif GetPricingAttained.CurrentRow EQ "#GetPricingAttained.RecordCount#">
<cfset CurrentPrice = "#customer_price#">
<cfset Display = "last">
</cfif>
</cfoutput>
<!--- LessThanExistsNOT Current=first GreaterThanExists --->
<cfelseif GetPricingUnattained.RecordCount NEQ "0" AND GetPricingAttained.RecordCount EQ "0">
<cfset CurrentPrice = "minimum not met">
<cfset Display = "first">
<!--- Current Quantity is 0 --->
<cfelse>
<cfset CurrentPrice = "call">
<cfset Display = "no orders">
</cfif>
<cfif Display EQ "no orders">
<tr bgcolor="yellow">
<td class="InfoTitles" align="right">0</td>
<td class="Informational" align="right">no orders</td>
</tr>
<cfoutput query="ProductPrices">
<!--- Display Higher Levels --->
<tr bgcolor="cococo">
<td class="InfoTitles" align="right">#quantity#</td>
<td class="Informational" align="right">#DollarFormat(customer_price)#</td>
</tr>
</cfoutput>
</cfif>
<!--- Display the Current Level --->
<cfif Display EQ "first">
<tr bgcolor="yellow">
<td class="InfoTitles" align="right">
<cfoutput>#NumberFormat(QuantityToday, "999,999"

#</cfoutput>
</td>
<td class="Informational" align="right">
<cfoutput>#CurrentPrice#</cfoutput>
</td>
</tr>
</cfif>
<cfif GetPricingAttained.RecordCount NEQ "0">
<cfoutput query="GetPricingAttained">
<!--- Display Lower Levels --->
<tr bgcolor="cococo">
<td class="InfoTitles" align="right">#LessThan#</td>
<td class="Informational" align="right">#DollarFormat(customer_price)#</td>
</tr>
</cfoutput>
</cfif>
<!--- Display the Current Level --->
<cfif Display EQ "middle">
<tr bgcolor="yellow">
<td class="InfoTitles" align="right">
<cfoutput>#NumberFormat(QuantityToday, "999,999"

#</cfoutput>
</td>
<td class="Informational" align="right">
<cfoutput>#DollarFormat(CurrentPrice)#</cfoutput>
</td>
</tr>
</cfif>
<!--- Display Higher Levels --->
<cfif GetPricingUnattained.RecordCount NEQ "0">
<cfoutput query="GetPricingUnattained">
<tr bgcolor="cococo">
<td class="InfoTitles" align="right">#GreaterThan#</td>
<td class="Informational" align="right">#DollarFormat(customer_price)#</td>
</tr>
</cfoutput>
</cfif>
<!--- Display the Current Level --->
<cfif Display EQ "last">
<tr bgcolor="yellow">
<td class="InfoTitles" align="right">
<cfoutput>#NumberFormat(QuantityToday, "999,999"

#</cfoutput>
</td>
<td class="Informational" align="right">
<cfoutput>#DollarFormat(CurrentPrice)#</cfoutput>
</td>
</tr>
</cfif>