DBA Data[Home] [Help]

APPS.FTE_TL_RATING dependencies on WSH_CARRIER_VEHICLE_TYPES

Line 158: FROM wsh_carrier_vehicle_types wcvt,

154:
155: CURSOR get_lane_carrier_vehicles(c_lane_id IN NUMBER) IS
156: SELECT wcvt.vehicle_type_id,
157: l.carrier_id
158: FROM wsh_carrier_vehicle_types wcvt,
159: fte_lanes l
160: WHERE l.lane_id=c_lane_id
161: and l.carrier_id=wcvt.carrier_id
162: and wcvt.assigned_flag='Y';

Line 169: FROM wsh_carrier_vehicle_types wcvt,

165: --Gets all the vehicles for the carrier of the schedule.
166: CURSOR get_schedule_carrier_vehicles(c_schedule_id IN NUMBER) IS
167: SELECT wcvt.vehicle_type_id,
168: l.carrier_id
169: FROM wsh_carrier_vehicle_types wcvt,
170: fte_lanes l ,
171: fte_schedules s
172: WHERE s.schedules_id=c_schedule_id
173: and l.lane_id=s.lane_id