APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on WSH_FREIGHT_COSTS

Line 3646: from wsh_freight_costs wfc,

3642: ts.trip_id = trip.trip_id;
3643:
3644: cursor legs_priced_cur( c_trip_id NUMBER) is
3645: select 1
3646: from wsh_freight_costs wfc,
3647: wsh_trip_stops wts,
3648: wsh_delivery_legs wdl
3649: where wts.trip_id = c_trip_id
3650: and wdl.pick_up_stop_id = wts.stop_id

Line 3659: from wsh_freight_costs wfc

3655:
3656:
3657: cursor leg_price_cur( c_dleg_id NUMBER) is
3658: select NVL(wfc.total_amount,0) price
3659: from wsh_freight_costs wfc
3660: where wfc.delivery_leg_id = c_dleg_id
3661: and wfc.line_type_code = 'SUMMARY'
3662: and wfc.delivery_detail_id is null
3663: and NVL(wfc.total_amount,0) > 0;