[Home] [Help]
1015:
1016: CURSOR class_process_loss_cursor (v_routing_class VARCHAR2, v_qty NUMBER)
1017: IS
1018: SELECT process_loss
1019: FROM gmd_process_loss
1020: WHERE v_qty <= NVL (max_quantity, v_qty)
1021: AND routing_class = v_routing_class
1022: ORDER BY max_quantity;
1023: