APPS.WSH_PR_PICKING_SESSION dependencies on WSH_PICK_SLIP_RULES

Line 194: FROM WSH_PICK_SLIP_RULES

190:
191: -- cursor to determine if pick slip rule contains order number
192: CURSOR order_ps_group(x_psr_id IN BINARY_INTEGER) IS
193: SELECT NVL(ORDER_NUMBER_FLAG,'N')
194: FROM WSH_PICK_SLIP_RULES
195: WHERE PICK_SLIP_RULE_ID = x_psr_id
196: AND SYSDATE BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE)) AND
197: NVL(END_DATE_ACTIVE, TRUNC(SYSDATE)+1);
198: