APPS.CSD_PROCESS_PVT dependencies on WSH_PICKING_RULES

Line 1337: FROM WSH_PICKING_RULES

1333: -- end bug#8269688, FP of bug#7659800, subhat
1334:
1335: CURSOR pick_rule(x_rule_id IN NUMBER) IS
1336: SELECT PICKING_RULE_ID
1337: FROM WSH_PICKING_RULES
1338: WHERE PICKING_RULE_ID = x_rule_id
1339: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND
1340: NVL(END_DATE_ACTIVE, SYSDATE + 1);
1341:

Line 1722: FROM WSH_PICKING_RULES

1718: l_batch_rec.project_id,
1719: l_batch_rec.task_id,
1720: l_batch_rec.Include_Planned_Lines,
1721: l_batch_rec.Autocreate_Delivery_Flag
1722: FROM WSH_PICKING_RULES
1723: WHERE PICKING_RULE_ID = p_order_rec.PICKING_RULE_ID;
1724:
1725:
1726: Exception

Line 2434: FROM wsh_picking_rules

2430:
2431: --R12 Development Changes Begin
2432: CURSOR cur_pick_rules(p_pick_rule_id NUMBER) IS
2433: SELECT 'x'
2434: FROM wsh_picking_rules
2435: WHERE picking_rule_id = p_pick_rule_id
2436: AND SYSDATE BETWEEN NVL(start_Date_Active, SYSDATE) AND
2437: NVL(end_Date_active, SYSDATE + 1);
2438: --R12 Development Changes End

Line 3731: FROM wsh_picking_rules

3727: -- Get the Picking Rule Id
3728: BEGIN
3729: SELECT picking_rule_id
3730: INTO l_picking_rule_id
3731: FROM wsh_picking_rules
3732: WHERE picking_rule_id = l_picking_rule_id;
3733: EXCEPTION
3734: WHEN NO_DATA_FOUND THEN
3735: Fnd_Message.SET_NAME('CSD',

Line 8665: FROM wsh_picking_rules

8661: END IF;
8662: BEGIN
8663: SELECT picking_rule_id
8664: INTO l_picking_rule_id
8665: FROM wsh_picking_rules
8666: WHERE picking_rule_id = l_picking_rule_id
8667: AND SYSDATE BETWEEN
8668: NVL(start_date_active, SYSDATE) AND
8669: NVL(end_date_active, SYSDATE + 1);