APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on WSH_TRIPS

Line 204: L_SHIP_METHOD_CODE WSH_TRIPS.SHIP_METHOD_CODE%TYPE;

200: ,DEL_ORGANIZATION_ID IN NUMBER
201: ,DELIVERY_ID1 IN NUMBER) RETURN CHAR IS
202: L_CARRIER VARCHAR2(35);
203: L_COUNT NUMBER;
204: L_SHIP_METHOD_CODE WSH_TRIPS.SHIP_METHOD_CODE%TYPE;
205: L_TRIP_PRESENT BOOLEAN := FALSE;
206: L_SHIP_METHOD_MEANING VARCHAR2(50);
207: BEGIN
208: /*SRW.REFERENCE(CARRIER_NAME)*/NULL;

Line 237: WSH_TRIPS WT,

233: SELECT
234: WT.SHIP_METHOD_CODE
235: INTO L_SHIP_METHOD_CODE
236: FROM
237: WSH_TRIPS WT,
238: WSH_TRIP_STOPS WTS,
239: WSH_DELIVERY_ASSIGNMENTS_V WDA,
240: WSH_DELIVERY_LEGS WDL
241: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID