APPS.FTE_DELIVERY_LEGS_PVT dependencies on WSH_NEW_DELIVERIES

Line 335: FROM wsh_new_deliveries

331:
332: CURSOR dlvy_weight_volume_cur (p_dlvy_id NUMBER)
333: IS
334: SELECT weight_uom_code,volume_uom_code
335: FROM wsh_new_deliveries
336: WHERE delivery_id = p_dlvy_id;
337:
338:
339: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line 2109: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl

2105: -- GET PARENT DELIVERY INFO
2106: CURSOR get_parent_dlvy_info_cur (c_parentDLegId NUMBER)
2107: IS
2108: SELECT wnd.delivery_id, wnd.name
2109: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl
2110: WHERE wdl.delivery_leg_id = c_parentDLegId
2111: AND wdl.delivery_id = wnd.delivery_id;
2112: --
2113: --