APPS.WSH_FREIGHT_COSTS_PVT dependencies on WSH_TRIP_STOPS

Line 1825: from wsh_trip_stops

1821: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Get_Trip_Freight_Cost';
1822:
1823: cursor c_get_stops(p_tripid NUMBER) is
1824: select stop_id
1825: from wsh_trip_stops
1826: where trip_id=p_tripid;
1827:
1828: cursor c_get_dels(p_tripid NUMBER) is
1829: select delivery_id

Line 1830: from wsh_delivery_legs wdl, wsh_trip_stops wts

1826: where trip_id=p_tripid;
1827:
1828: cursor c_get_dels(p_tripid NUMBER) is
1829: select delivery_id
1830: from wsh_delivery_legs wdl, wsh_trip_stops wts
1831: where wdl.pick_up_stop_id=wts.stop_id
1832: and wts.trip_id=p_tripid;
1833:
1834: Cursor freight_cost_at_trip(c_trip_id number) IS