DBA Data[Home] [Help]

APPS.FTE_TL_CACHE dependencies on FTE_LANE_RATE_CHARTS

Line 322: FROM fte_lane_rate_charts flrc

318: c_departure_date IN DATE,
319: c_arrival_date IN DATE)
320: IS
321: SELECT flrc.list_header_id
322: FROM fte_lane_rate_charts flrc
323: WHERE flrc.lane_id = c_lane_id
324: AND (flrc.start_date_active is null
325: OR flrc.start_date_active <= c_departure_date )
326: AND (flrc.end_date_active is null

Line 7300: fte_lane_rate_charts flrc

7296: l.mode_of_transportation_code,
7297: l.service_type_code,
7298: flrc.list_header_id
7299: FROM fte_lanes l,
7300: fte_lane_rate_charts flrc
7301: WHERE l.lane_id=c_lane_id
7302: AND (l.lane_id = flrc.lane_id )
7303: AND (flrc.start_date_active is null
7304: OR flrc.start_date_active <= x_trip_rec.planned_departure_date )

Line 7384: fte_lane_rate_charts flrc

7380: s.schedules_id,
7381: flrc.list_header_id
7382: FROM fte_lanes l,
7383: fte_schedules s,
7384: fte_lane_rate_charts flrc
7385: WHERE l.lane_id=s.lane_id
7386: AND (l.lane_id = flrc.lane_id )
7387: AND (flrc.start_date_active is null
7388: OR flrc.start_date_active <= x_trip_rec.planned_departure_date )