APPS.FTE_TL_RATING dependencies on FTE_SCHEDULES

Line 147: FTE_SCHEDULES s

143: CURSOR get_schedule_def_vehicle(c_schedule_id IN NUMBER) IS
144: SELECT c.default_vehicle_type_id
145: FROM WSH_CARRIER_SERVICES c ,
146: FTE_LANES l,
147: FTE_SCHEDULES s
148: WHERE c.carrier_id=l.carrier_id and
149: c.service_level=l.service_type_code and
150: s.schedules_id=c_schedule_id and
151: s.lane_id=l.lane_id;

Line 171: fte_schedules s

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
174: and l.carrier_id=wcvt.carrier_id
175: and wcvt.assigned_flag='Y';