782: WHERE trip_id = p_trip_id;
783:
784: CURSOR freight_costs_exist IS
785: SELECT freight_cost_id
786: FROM wsh_freight_costs
787: WHERE trip_id = p_trip_id
788: FOR UPDATE NOWAIT;
789:
790: l_status_code VARCHAR2(2);
1438: FOR UPDATE NOWAIT;
1439:
1440: CURSOR freight_costs_exist IS
1441: SELECT freight_cost_id
1442: FROM wsh_freight_costs
1443: WHERE stop_id = p_stop_id
1444: FOR UPDATE NOWAIT;
1445:
1446: l_trip_status_code VARCHAR2(2);