APPS.WSH_PR_CRITERIA dependencies on WSH_PICK_GROUPING_RULES

Line 1562: FROM WSH_PICK_GROUPING_RULES

1558:
1559: -- cursor to determine if pick slip rule contains order number and delivery
1560: CURSOR order_ps_group(v_pgr_id IN NUMBER) IS
1561: SELECT NVL(ORDER_NUMBER_FLAG,'N'), NVL(DELIVERY_FLAG,'N')
1562: FROM WSH_PICK_GROUPING_RULES
1563: WHERE PICK_GROUPING_RULE_ID = v_pgr_id
1564: AND SYSDATE BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE)) AND
1565: NVL(END_DATE_ACTIVE, TRUNC(SYSDATE)+1);
1566: