DBA Data[Home] [Help]

APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on AR_LOOKUPS

Line 667: AR_LOOKUPS

663: SELECT
664: MEANING || ' ' || CONTACT_NAME
665: INTO CONTACT_NAME
666: FROM
667: AR_LOOKUPS
668: WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
669: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
670: EXCEPTION
671: WHEN OTHERS THEN

Line 722: AR_LOOKUPS

718: SELECT
719: MEANING || ' ' || CONTACT_NAME
720: INTO CONTACT_NAME
721: FROM
722: AR_LOOKUPS
723: WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
724: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
725: EXCEPTION
726: WHEN OTHERS THEN

Line 775: AR_LOOKUPS

771: SELECT
772: MEANING || ' ' || BILL_TO_CUST_NAME
773: INTO BILL_TO_CUST_NAME
774: FROM
775: AR_LOOKUPS
776: WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
777: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
778: EXCEPTION
779: WHEN OTHERS THEN

Line 855: AR_LOOKUPS

851: SELECT
852: MEANING || ' ' || SHIP_TO_CUST_NAME
853: INTO SHIP_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