DBA Data[Home] [Help]

APPS.FTE_TL_RATING dependencies on WSH_CARRIER_SERVICES

Line 136: FROM WSH_CARRIER_SERVICES c ,

132:
133: --Gets the default vehicle for the lane through the carrier service level.
134: CURSOR get_lane_def_vehicle (c_lane_id IN NUMBER) IS
135: SELECT c.default_vehicle_type_id
136: FROM WSH_CARRIER_SERVICES c ,
137: FTE_LANES l
138: WHERE c.carrier_id=l.carrier_id and
139: c.service_level=l.service_type_code and
140: l.lane_id=c_lane_id;

Line 145: FROM WSH_CARRIER_SERVICES c ,

141:
142: --Gets the default vehicle for the schedule through the carrier service level.
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