359: SELECT
360: MEANING || ' ' || SHIP_TO_CUST_NAME
361: INTO SHIP_TO_CUST_NAME
362: FROM
363: AR_LOOKUPS
364: WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
365: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
366: EXCEPTION
367: WHEN OTHERS THEN
416: SELECT
417: MEANING || ' ' || CONTACT_NAME
418: INTO CONTACT_NAME
419: FROM
420: AR_LOOKUPS
421: WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
422: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
423: EXCEPTION
424: WHEN OTHERS THEN