APPS.WSH_AUTO_MANIFEST dependencies on HZ_PARTIES

Line 307: FROM wsh_carriers, hz_parties

303: OR ( wnd.initial_pickup_date <= p_scheduled_to_date));
304:
305: CURSOR get_carrier_name(pc_carrier_id NUMBER) IS
306: SELECT party_name
307: FROM wsh_carriers, hz_parties
308: WHERE carrier_id =party_id (+)
309: AND carrier_id= pc_carrier_id;
310:
311: CURSOR get_customer_name(pc_customer_id NUMBER) IS

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 */