APPS.FTE_TRIPS_PVT dependencies on WSH_DELIVERY_LEGS

Line 1043: from wsh_delivery_legs wdl, wsh_trip_stops wts

1039: l_noofrows BINARY_INTEGER;
1040:
1041: cursor c_dlegs(p_del_id NUMBER) is
1042: select delivery_leg_id
1043: from wsh_delivery_legs wdl, wsh_trip_stops wts
1044: where wdl.pick_up_stop_id = wts.stop_id
1045: and wts.trip_id = p_wsh_trip_id
1046: and wdl.delivery_id=p_del_id;
1047:

Line 1068: UPDATE wsh_delivery_legs SET fte_trip_id=p_fte_trip_id

1064:
1065: for c_dleg in c_dlegs(l_del_id) loop
1066: l_dleg_id:=c_dleg.delivery_leg_id;
1067:
1068: UPDATE wsh_delivery_legs SET fte_trip_id=p_fte_trip_id
1069: where delivery_leg_id=l_dleg_id;
1070:
1071: IF (SQL%NOTFOUND) THEN
1072: RAISE no_data_found;

Line 1414: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,

1410: --
1411: CURSOR get_org_info_cur (c_stop_id IN NUMBER)
1412: IS
1413: SELECT distinct(org.organization_name) org_name
1414: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
1415: wsh_trip_stops stops, org_organization_definitions org
1416: WHERE dlegs.delivery_id = dlvy.delivery_id
1417: AND dlegs.pick_up_stop_id = stops.stop_id
1418: AND org.organization_id = dlvy.organization_id

Line 1627: wsh_delivery_legs wdl --d

1623: FROM wsh_new_deliveries
1624: WHERE delivery_id IN
1625: (SELECT distinct(wdl.delivery_id)
1626: FROM wsh_trip_stops wts, --t
1627: wsh_delivery_legs wdl --d
1628: WHERE wdl.pick_up_stop_id = wts.stop_id
1629: AND wts.trip_id = l_trip_id);
1630: --}
1631: