APPS.WSH_AUTO_MANIFEST dependencies on HZ_CUST_ACCOUNTS

Line 313: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP

309: AND carrier_id= pc_carrier_id;
310:
311: CURSOR get_customer_name(pc_customer_id NUMBER) IS
312: SELECT HP.PARTY_NAME
313: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP
314: WHERE HP.PARTY_ID = HCA.PARTY_ID
315: AND HP.PARTY_ID = pc_customer_id;
316:
317: /*Patchset I: Locations Project. Use ui_location_code from wsh_customer_locations_v */