397: if (usercolon = 0) then
398: -- very costly sql statement, return the first row we find.
399: select ORIG_SYSTEM, ORIG_SYSTEM_ID
400: into uos, uosid
401: from WF_USERS
402: where NAME = username
403: and ORIG_SYSTEM not in ('HZ_PARTY','CUST_CONT')
404: and rownum < 2;
405: else