329: SELECT
330: MEANING || ' ' || SHIP_TO_CUST_NAME
331: INTO SHIP_TO_CUST_NAME
332: FROM
333: AR_LOOKUPS
334: WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
335: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
336: EXCEPTION
337: WHEN OTHERS THEN
385: SELECT
386: MEANING || ' ' || CONTACT_NAME
387: INTO CONTACT_NAME
388: FROM
389: AR_LOOKUPS
390: WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
391: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
392: EXCEPTION
393: WHEN OTHERS THEN