APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on AR_LOOKUPS

Line 747: AR_LOOKUPS

743: SELECT
744: MEANING || ' ' || CONTACT_NAME
745: INTO CONTACT_NAME
746: FROM
747: AR_LOOKUPS
748: WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
749: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
750: EXCEPTION
751: WHEN OTHERS THEN

Line 802: AR_LOOKUPS

798: SELECT
799: MEANING || ' ' || CONTACT_NAME
800: INTO CONTACT_NAME
801: FROM
802: AR_LOOKUPS
803: WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
804: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
805: EXCEPTION
806: WHEN OTHERS THEN

Line 855: AR_LOOKUPS

851: SELECT
852: MEANING || ' ' || BILL_TO_CUST_NAME
853: INTO BILL_TO_CUST_NAME
854: FROM
855: AR_LOOKUPS
856: WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
857: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
858: EXCEPTION
859: WHEN OTHERS THEN

Line 893: AR_LOOKUPS

889: SELECT
890: MEANING || ' ' || BILL_TO_CUST_NAME
891: INTO BILL_TO_CUST_NAME
892: FROM
893: AR_LOOKUPS
894: WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
895: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
896: EXCEPTION
897: WHEN OTHERS THEN

Line 1000: AR_LOOKUPS

996: SELECT
997: MEANING || ' ' || SHIP_TO_CUST_NAME
998: INTO SHIP_TO_CUST_NAME
999: FROM
1000: AR_LOOKUPS
1001: WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
1002: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
1003: EXCEPTION
1004: WHEN OTHERS THEN