Why does my Profile Variable not work in Contact Center?

I have a SQL query in SQL Developer for a specified account_number that returns the account_number where relationship_type ='MICR':

select account_number

from apps.hz_cust_accounts

where cust_account_id  in (

        select AC.related_cust_account_id

        from apps.hz_cust_acct_relate_all AC, apps.hz_cust_accounts CA

        where relationship_type = 'MICR'

        and ca.cust_account_id = AC.cust_account_id

        and CA.account_number = 'APEXPT0')

In this example the Account Number is APEXPT0.  There is a Relationship to Account Number 5006912 which has a Relationship Type of MICR. 

I am trying to get this account number to show in Contact Center Dashboard (Service ->Customer Management->Contact Center).  Therefore, I am doing the setup in Service->Setup->Customer Management->Customer Profile Setup -> Profile Variables.  I have to modify the query slight to fit the fields in this form (and include bind :party_id).  When I save it and validate it in Contact Center, it shows 0 as the result when in fact it should show the correct account number 202838.