[Home] [Help]
144: WHERE transaction_interface_id = p_transaction_id;
145:
146: CURSOR c_wnd_lpn IS
147: SELECT wdd2.lpn_id
148: FROM wsh_new_deliveries wnd
149: , wsh_delivery_assignments_v wda
150: , wsh_delivery_details wdd1
151: , wsh_delivery_details wdd2
152: WHERE wnd.delivery_id = p_transaction_id