APPS.OKE_DSNO_PKG dependencies on WSH_DELIVERY_DETAILS

Line 20: FROM wsh_delivery_details w, wsh_delivery_assignments_v a

16: l_oke_id NUMBER;
17:
18: CURSOR oke_c ( p_delivery_id NUMBER, p_oke_id NUMBER ) IS
19: SELECT w.source_line_id
20: FROM wsh_delivery_details w, wsh_delivery_assignments_v a
21: WHERE a.delivery_id = p_delivery_id
22: AND w.source_code = 'OKE'
23: AND w.delivery_detail_id = a.delivery_detail_id
24: AND w.source_header_id = p_oke_id;

Line 64: FROM wsh_delivery_details w, wsh_delivery_assignments_v a

60: l_oke_id NUMBER;
61:
62: CURSOR oke_c ( p_delivery_id NUMBER, p_oke_id NUMBER ) IS
63: SELECT w.source_line_id
64: FROM wsh_delivery_details w, wsh_delivery_assignments_v a
65: WHERE a.delivery_id = p_delivery_id
66: AND w.source_code = 'OKE'
67: AND w.delivery_detail_id = a.delivery_detail_id
68: AND w.source_header_id = p_oke_id;

Line 105: FROM wsh_delivery_details w, wsh_delivery_assignments_v a

101: WHERE deliverable_id=p_deliverable_id;
102:
103: CURSOR oke_c ( p_delivery_id NUMBER, p_oke_id NUMBER ) IS
104: SELECT w.source_line_id
105: FROM wsh_delivery_details w, wsh_delivery_assignments_v a
106: WHERE a.delivery_id = p_delivery_id
107: AND w.source_code = 'OKE'
108: AND w.delivery_detail_id = a.delivery_detail_id
109: AND w.source_header_id = p_oke_id;