DBA Data[Home] [Help]

APPS.WSH_PROCESS_INTERFACED_PKG dependencies on WSH_TRIP_STOPS_INTERFACE

Line 1736: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi

1732: IS
1733: SELECT wdli.delivery_leg_interface_id,
1734: wdli.pick_up_stop_interface_id,
1735: wdli.drop_off_stop_interface_id, wtsi.trip_interface_id
1736: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi
1737: WHERE wdli.delivery_interface_id = p_delivery_interface_id
1738: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id
1739: AND wdli.INTERFACE_ACTION_CODE = '94X_INBOUND'
1740: AND wtsi.INTERFACE_ACTION_CODE = '94X_INBOUND';

Line 1777: DELETE wsh_trip_stops_interface

1773: DELETE wsh_del_legs_interface
1774: WHERE delivery_leg_interface_id = ids_rec.delivery_leg_interface_id
1775: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1776:
1777: DELETE wsh_trip_stops_interface
1778: WHERE stop_interface_id IN
1779: (ids_rec.pick_up_stop_interface_id,
1780: ids_rec.drop_off_stop_interface_id
1781: )