APPS.WSH_TPA_SELECTOR_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 25: FROM wsh_delivery_assignments_v

21: x_tp_group_code OUT NOCOPY VARCHAR2) IS
22:
23: CURSOR Get_First_Line IS
24: SELECT delivery_detail_id
25: FROM wsh_delivery_assignments_v
26: WHERE delivery_id = p_delivery_id
27: AND rownum < 2;
28:
29: l_del_detail_id NUMBER;

Line 104: FROM wsh_delivery_assignments_v

100:
101:
102: CURSOR Get_First_Line IS
103: SELECT delivery_detail_id
104: FROM wsh_delivery_assignments_v
105: WHERE parent_delivery_detail_id = p_container_instance_id
106: AND rownum < 2;
107:
108: l_del_detail_id NUMBER;