284:
285: update pon_item_prices_interface p1
286: set ship_to_location = (select st.location_code
287: from po_ship_to_loc_org_v st,
288: financials_system_params_all fsp,
289: pon_auction_item_prices_all pal
290: where p1.batch_id = p_batch_id
291: and p1.action = g_update_action
292: and p1.auction_header_id = pal.auction_header_id