DBA Data[Home] [Help]

APPS.GMDRTVAL_PUB dependencies on GMD_PROCESS_LOSS

Line 41: FROM gmd_process_loss

37: /* Cursor Definitions. */
38: /* =================== */
39: CURSOR Cur_get_process_loss IS
40: SELECT process_loss
41: FROM gmd_process_loss
42: WHERE routing_class = prouting_class
43: AND NVL(max_quantity, 2147484647) >= NVL(pquantity,2147484647)
44: ORDER BY max_quantity;
45:

Line 706: FROM gmd_process_loss

702: l_rows NUMBER := 1;
703:
704: Cursor max_qty_cur(pRouting_class VARCHAR2, pFromMaxQty NUMBER, pToMaxQty NUMBER) IS
705: SELECT max_quantity
706: FROM gmd_process_loss
707: WHERE routing_class = pRouting_class AND
708: max_quantity > pFromMaxQty AND
709: max_quantity <= pToMaxQty;
710: