APPS.ASO_WORKFLOW_QUOTE_PVT dependencies on HZ_PARTY_SITES

Line 427: FROM hz_party_sites

423: rtrim(postal_code) loc_zip,
424: rtrim(country) loc_country
425: FROM hz_locations
426: WHERE location_id = ( SELECT location_id
427: FROM hz_party_sites
428: WHERE party_site_id = p_loc_site_id);
429: Cursor c_aso_shipments(p_quote_id NUMBER) IS
430: SELECT ship_to_cust_account_id, ship_to_party_site_id, ship_to_party_id, ship_method_code
431: FROM aso_shipments