DBA Data[Home] [Help]

APPS.JAI_WSH_EXP_HANDLING_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 114: cursor c_get_delivery_details(p_delivery_id wsh_delivery_assignments.delivery_id%type)

110: lv_return_msg VARCHAR2(240);
111: lv_delivery_id NUMBER;
112: lv_exp_entity VARCHAR2(30);
113:
114: cursor c_get_delivery_details(p_delivery_id wsh_delivery_assignments.delivery_id%type)
115: is
116: SELECT *
117: FROM wsh_delivery_details
118: WHERE delivery_detail_id IN

Line 122: wsh_delivery_assignments

118: WHERE delivery_detail_id IN
119: ( SELECT
120: delivery_detail_id
121: FROM
122: wsh_delivery_assignments
123: WHERE
124: delivery_id = p_delivery_id
125: );
126: