APPS.WSH_AUTO_MANIFEST dependencies on HZ_CUST_ACCOUNTS

Line 416: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP

412: AND carrier_id= pc_carrier_id;
413:
414: CURSOR get_customer_name(pc_customer_id NUMBER) IS
415: SELECT HP.PARTY_NAME
416: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP
417: WHERE HP.PARTY_ID = HCA.PARTY_ID
418: AND HP.PARTY_ID = pc_customer_id;
419:
420: /*Patchset I: Locations Project. Use ui_location_code from wsh_customer_locations_v */