[Home] [Help]
226: IF ( (Cur_get_trans_pnd_rec.doc_type = 'XFER')
227: AND (Cur_get_trans_cmp_rec.whse_code <> pto_whse_code)
228: ) THEN
229:
230: UPDATE IC_XFER_MST
231: SET FROM_WAREHOUSE = pto_whse_code,
232: FROM_LOCATION = pto_location,
233: LAST_UPDATED_BY = l_user_id,
234: LAST_UPDATE_DATE = SYSDATE