DBA Data[Home] [Help]

APPS.FTE_TRIPS_PVT dependencies on WSH_TRIPS

Line 689: FROM fte_wsh_trips

685: ) IS
686:
687: CURSOR trip_segments (l_trip_id IN NUMBER) IS
688: SELECT wsh_trip_id
689: FROM fte_wsh_trips
690: WHERE fte_trip_id = l_trip_id;
691:
692: l_trip_id NUMBER;
693: l_wsh_trip_ids NUMBER;

Line 740: FROM fte_wsh_trips

736: ) IS
737:
738: CURSOR trip_segments (l_trip_id IN NUMBER) IS
739: SELECT wsh_trip_id, sequence_number
740: FROM fte_wsh_trips
741: WHERE fte_trip_id = l_trip_id
742: order by sequence_number;
743:
744: CURSOR trip_stops (l_wsh_trip_id IN NUMBER) IS

Line 1106: from wsh_trips

1102: l_trip_id NUMBER := -9999;
1103:
1104: cursor get_trip_cur(c_tender_number NUMBER) is
1105: select trip_id
1106: from wsh_trips
1107: where load_tender_number = c_tender_number;
1108:
1109: BEGIN
1110:

Line 1320: FROM wsh_trips

1316: --
1317: CURSOR get_trip_segment_cur
1318: IS
1319: SELECT name
1320: FROM wsh_trips
1321: WHERE trip_id = p_trip_segment_id;
1322: --}
1323: BEGIN
1324: --{