[Home] [Help]
APPS.FTE_TENDER_PVT dependencies on WSH_EXCEPTIONS
Line 3546: wsh_exceptions we, wsh_trips wt where we.trip_id = wt.trip_id and
3542: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT'|| '.' || 'COMPLETE_CANCEL_TENDER';
3543:
3544: cursor check_exception_on_trip(p_tender_id Number) is
3545: select exception_id, status from
3546: wsh_exceptions we, wsh_trips wt where we.trip_id = wt.trip_id and
3547: (we.exception_name = 'FTE_CARRIER_PTIME' OR
3548: we.exception_name = 'FTE_CARRIER_DTIME') AND
3549: we.status <> 'CLOSED' AND
3550: wt.trip_id = p_tender_id;