APPS.ASO_WORKFLOW_PVT dependencies on HZ_PARTY_SITES

Line 308: FROM hz_party_sites

304: rtrim(postal_code) loc_zip,
305: rtrim(country) loc_country
306: FROM hz_locations
307: WHERE location_id = ( SELECT location_id
308: FROM hz_party_sites
309: WHERE party_site_id = p_loc_site_id);
310: Cursor c_aso_shipments(p_quote_id NUMBER) IS
311: SELECT ship_to_cust_account_id, ship_to_party_site_id, ship_to_party_id, ship_method_code
312: FROM aso_shipments