Aurena - Lobby element working in IEE but does not work in Aurena

I have created a counter element for one of my Aurena Lobbies. This element works in IEE but not in Aurena. The counter populates the correct number in Aurena but when I click on the element, I get a Server Error when it is trying to filter out using my data source condition on the Business Opportunities screen. Something to note, I am including a custom lu table in my query.

This is the query I am using in the data source. The lobby takes 3 parameters (Sales_0, Sales_1, Sales_2). The query is supposed to be help default the salesperson ID - if the user that is logged in has a salesperson ID (to prevent sales from needing to add their salesperson code into the parameters):

View: &AO.BUSINESS_OPPORTUNITY

Condition:

-- open BO status
STATE = 'Confirmed'
-- If the first parameter is empty then match on the salesperson code that is connected to the person logged in
AND (&AO.CUST_ORD_CUSTOMER_API.GET_SALESMAN_CODE(CUSTOMER_ID) = NVL(UPPER('$Sales_0$'),UPPER((SELECT 
                                                                                              CF$_SALESMAN_CODE 
                                                                                              FROM &AO.AURENA_SALESPERSON_RECORD_CLV 
                                                                                              WHERE CF$_PERSON_ID = '#PERSON_ID#')))
-- OR If more than 1 parameter is not empty then match on any of them
OR (&AO.CUST_ORD_CUSTOMER_API.GET_SALESMAN_CODE(CUSTOMER_ID) IN (NVL(UPPER('$Sales_0$'),UPPER((SELECT 
                                                                                               CF$_SALESMAN_CODE 
                                                                                               FROM &AO.AURENA_SALESPERSON_RECORD_CLV 
                                                                                               WHERE CF$_PERSON_ID = '#PERSON_ID#'))), UPPER('$Sales_1$'),UPPER('$Sales_2$'))))

This is the snippet of my Counter’s Navigation in the element designer: 

This is the specific error I am receiving from Aurena:

RESPONSE body "
{\"error\":
	{\"code\":\"ODATA_PROVIDER_ERROR\",
	\"message\":\"An internal server error occurred. Contact administrator.\",
	\"details\":
		[{\"message\":\"Value(s) not found for 
			[$_SALESMAN_CODE 
				FROM AURENA_SALESPERSON_RECORD_CLV 
				WHERE CF$] page parameter(s).\"}]
	}
}"

It’s a little odd that the message is containing only a little bit of my select statement where I call on my custom lu.

Anybody run into this error or know how to fix it?