APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on WSH_TRIPS

Line 56: L_SHIP_METHOD_CODE WSH_TRIPS.SHIP_METHOD_CODE%TYPE;

52: ,C_DEL_ORG_ID IN NUMBER
53: ,C_Q2_DELIVERY_ID IN NUMBER) RETURN VARCHAR2 IS
54: L_CARRIER VARCHAR2(35);
55: L_COUNT NUMBER;
56: L_SHIP_METHOD_CODE WSH_TRIPS.SHIP_METHOD_CODE%TYPE;
57: L_TRIP_PRESENT BOOLEAN := FALSE;
58: BEGIN
59: /*SRW.REFERENCE(C_SHIP_METHOD)*/NULL;
60: /*SRW.REFERENCE(C_DEL_ORG_ID)*/NULL;

Line 69: WSH_TRIPS WT,

65: SELECT
66: WT.SHIP_METHOD_CODE
67: INTO L_SHIP_METHOD_CODE
68: FROM
69: WSH_TRIPS WT,
70: WSH_TRIP_STOPS WTS,
71: WSH_DELIVERY_ASSIGNMENTS_V WDA,
72: WSH_DELIVERY_LEGS WDL
73: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID