444: l_pick_status := NULL;
445:
446: SELECT 'Y'
447: INTO l_pick_status
448: FROM WSH_DELIVERY_LINE_STATUS_V
449: WHERE SOURCE_CODE = 'OE'
450: AND SOURCE_LINE_ID = p_line_rec.line_id
451: AND PICK_STATUS IN('C','Y','S');
452: