APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on HZ_PARTIES

Line 325: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP

321: WHERE wsh_location_id=p_location_id;
322:
323: CURSOR get_customer_name(p_customer_id NUMBER) IS
324: SELECT HP.PARTY_NAME
325: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP
326: WHERE HP.PARTY_ID = HCA.PARTY_ID
327: AND HP.PARTY_ID = p_customer_id;
328:
329: l_del_name varchar2(240);

Line 843: HZ_PARTIES HP,

839: SELECT HL.LOCATION_ID,
840: HCA.CUST_ACCOUNT_ID,
841: HCSU.SITE_USE_ID
842: FROM HZ_CUST_ACCOUNTS HCA,
843: HZ_PARTIES HP,
844: HZ_CUST_SITE_USES_ALL HCSU,
845: HZ_CUST_ACCT_SITES_ALL HCAS,
846: -- ORG_ORGANIZATION_DEFINITIONS OOD,
847: HZ_PARTY_SITES HPS,

Line 875: HZ_PARTIES HP

871: HZ_CUST_ACCT_SITES_ALL HCAS,
872: HZ_PARTY_SITES HPS,
873: HZ_CUST_ACCOUNTS HCA,
874: HZ_CUST_ACCT_RELATE_ALL HCAR,
875: HZ_PARTIES HP
876: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
877: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
878: AND HCAS.CUST_ACCOUNT_ID = HCAR.CUST_ACCOUNT_ID
879: AND HCSU.SITE_USE_CODE IN (p_site_use_code, 'SHIP_TO')