[Home] [Help]
APPS.WSH_TRIP_VALIDATIONS dependencies on WSH_FREIGHT_COSTS
Line 786: FROM wsh_freight_costs
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);
Line 1442: FROM wsh_freight_costs
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);