APPS.WSH_PR_CRITERIA dependencies on WSH_PICK_GROUPING_RULES

Line 1501: FROM WSH_PICK_GROUPING_RULES

1497:
1498: -- cursor to determine if pick slip rule contains order number and delivery
1499: CURSOR order_ps_group(v_pgr_id IN NUMBER) IS
1500: SELECT NVL(ORDER_NUMBER_FLAG,'N'), NVL(DELIVERY_FLAG,'N')
1501: FROM WSH_PICK_GROUPING_RULES
1502: WHERE PICK_GROUPING_RULE_ID = v_pgr_id
1503: AND SYSDATE BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE)) AND
1504: NVL(END_DATE_ACTIVE, TRUNC(SYSDATE)+1);
1505: