APPS.WSH_PR_PICKING_SESSION dependencies on WSH_RELEASE_SEQ_RULES

Line 186: FROM WSH_RELEASE_SEQ_RULES

182: NVL(SHIPMENT_PRI_PRIORITY, -1),
183: DECODE(SHIPMENT_PRI_SORT, 'A', 'ASC', 'D', 'DESC', ''),
184: NVL(DEPARTURE_PRIORITY, -1),
185: DECODE(DEPARTURE_SORT, 'A', 'ASC', 'D', 'DESC', '')
186: FROM WSH_RELEASE_SEQ_RULES
187: WHERE RELEASE_SEQ_RULE_ID = x_rsr_id
188: AND SYSDATE BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE)) AND
189: NVL(END_DATE_ACTIVE, TRUNC(SYSDATE)+1);
190: