322: RETURN VARCHAR2
323: IS
324: CURSOR Cur_get_rework IS
325: SELECT rework_status
326: FROM GMD_STATUS_NEXT
327: WHERE current_status = p_from_status
328: AND target_status = p_to_status
329: AND pending_status IS NOT NULL;
330:
343: RETURN VARCHAR2
344: IS
345: CURSOR Cur_get_pending IS
346: SELECT pending_status
347: FROM GMD_STATUS_NEXT
348: WHERE current_status = p_from_status
349: AND target_status = p_to_status;
350:
351: l_pending_status VARCHAR2(30);