APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on HZ_PARTIES

Line 298: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP

294: WHERE wsh_location_id=p_location_id;
295:
296: CURSOR get_customer_name(p_customer_id NUMBER) IS
297: SELECT HP.PARTY_NAME
298: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP
299: WHERE HP.PARTY_ID = HCA.PARTY_ID
300: AND HP.PARTY_ID = p_customer_id;
301:
302: l_del_name varchar2(240);

Line 723: HZ_PARTIES HP,

719: SELECT HL.LOCATION_ID,
720: HCA.CUST_ACCOUNT_ID,
721: HCSU.SITE_USE_ID
722: FROM HZ_CUST_ACCOUNTS HCA,
723: HZ_PARTIES HP,
724: HZ_CUST_SITE_USES_ALL HCSU,
725: HZ_CUST_ACCT_SITES_ALL HCAS,
726: -- ORG_ORGANIZATION_DEFINITIONS OOD,
727: HZ_PARTY_SITES HPS,

Line 755: HZ_PARTIES HP

751: HZ_CUST_ACCT_SITES_ALL HCAS,
752: HZ_PARTY_SITES HPS,
753: HZ_CUST_ACCOUNTS HCA,
754: HZ_CUST_ACCT_RELATE_ALL HCAR,
755: HZ_PARTIES HP
756: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
757: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
758: AND HCAS.CUST_ACCOUNT_ID = HCAR.CUST_ACCOUNT_ID
759: AND HCSU.SITE_USE_CODE IN (p_site_use_code, 'SHIP_TO')