APPS.CSD_PROCESS_PVT dependencies on WSH_PICKING_RULES

Line 1300: FROM WSH_PICKING_RULES

1296: fail_api EXCEPTION;
1297:
1298: CURSOR pick_rule(x_rule_id IN NUMBER) IS
1299: SELECT PICKING_RULE_ID
1300: FROM WSH_PICKING_RULES
1301: WHERE PICKING_RULE_ID = x_rule_id
1302: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND
1303: NVL(END_DATE_ACTIVE, SYSDATE + 1);
1304:

Line 1685: FROM WSH_PICKING_RULES

1681: l_batch_rec.project_id,
1682: l_batch_rec.task_id,
1683: l_batch_rec.Include_Planned_Lines,
1684: l_batch_rec.Autocreate_Delivery_Flag
1685: FROM WSH_PICKING_RULES
1686: WHERE PICKING_RULE_ID = p_order_rec.PICKING_RULE_ID;
1687:
1688:
1689: Exception

Line 2351: FROM wsh_picking_rules

2347:
2348: --R12 Development Changes Begin
2349: CURSOR cur_pick_rules(p_pick_rule_id NUMBER) IS
2350: SELECT 'x'
2351: FROM wsh_picking_rules
2352: WHERE picking_rule_id = p_pick_rule_id
2353: AND SYSDATE BETWEEN NVL(start_Date_Active, SYSDATE) AND
2354: NVL(end_Date_active, SYSDATE + 1);
2355: --R12 Development Changes End

Line 3635: FROM wsh_picking_rules

3631: -- Get the Picking Rule Id
3632: BEGIN
3633: SELECT picking_rule_id
3634: INTO l_picking_rule_id
3635: FROM wsh_picking_rules
3636: WHERE picking_rule_id = l_picking_rule_id;
3637: EXCEPTION
3638: WHEN NO_DATA_FOUND THEN
3639: Fnd_Message.SET_NAME('CSD',

Line 8510: FROM wsh_picking_rules

8506: END IF;
8507: BEGIN
8508: SELECT picking_rule_id
8509: INTO l_picking_rule_id
8510: FROM wsh_picking_rules
8511: WHERE picking_rule_id = l_picking_rule_id
8512: AND SYSDATE BETWEEN
8513: NVL(start_date_active, SYSDATE) AND
8514: NVL(end_date_active, SYSDATE + 1);