SELECT a.cust_account_id
      ,a.account_number
       /*,hz_utility_v2pub.get_lookupmeaning('FND_LOOKUP_VALUES' 
         ,'CUSTOMER CLASS' 
         ,a.customer_class_code) AS customer_class_code */
      ,a.account_established_date
  FROM hz_cust_accounts     a
      ,hz_customer_profiles p
 WHERE a.account_number = x_customer_rec.customer_number
   AND p.cust_account_id = a.cust_account_id
   AND p.site_use_id IS NULL;