DBA Data[Home] [Help]

APPS.CLN_SHOWSHIP_PKG dependencies on HZ_PARTY_SITES

Line 153: from wsh_new_deliveries wnd, wsh_locations wl, hz_party_sites hps

149:
150: -- cursor to hold the XML Setup Check query and to retrieve the current time stamp date
151: CURSOR c_XML_Setup IS
152: select hps.party_site_id, hps.party_id, wnd.asn_date_sent, wnd.asn_seq_number, wnd.organization_id
153: from wsh_new_deliveries wnd, wsh_locations wl, hz_party_sites hps
154: where wnd.delivery_id = p_delivery_id
155: and wnd.ultimate_dropoff_location_id = wl.wsh_location_id
156: and wl.LOCATION_SOURCE_CODE = 'HZ'
157: and wl.SOURCE_LOCATION_ID = hps.location_id;