APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on WSH_TRIPS

Line 71: L_SHIP_METHOD_CODE WSH_TRIPS.SHIP_METHOD_CODE%TYPE;

67: ,C_DEL_ORG_ID IN NUMBER
68: ,C_Q2_DELIVERY_ID IN NUMBER) RETURN VARCHAR2 IS
69: L_CARRIER VARCHAR2(35);
70: L_COUNT NUMBER;
71: L_SHIP_METHOD_CODE WSH_TRIPS.SHIP_METHOD_CODE%TYPE;
72: L_TRIP_PRESENT BOOLEAN := FALSE;
73: BEGIN
74: /*SRW.REFERENCE(C_SHIP_METHOD)*/NULL;
75: /*SRW.REFERENCE(C_DEL_ORG_ID)*/NULL;

Line 84: WSH_TRIPS WT,

80: SELECT
81: WT.SHIP_METHOD_CODE
82: INTO L_SHIP_METHOD_CODE
83: FROM
84: WSH_TRIPS WT,
85: WSH_TRIP_STOPS WTS,
86: WSH_DELIVERY_ASSIGNMENTS_V WDA,
87: WSH_DELIVERY_LEGS WDL
88: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID