APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on WSH_ORG_CARRIER_SERVICES

Line 114: WSH_ORG_CARRIER_SERVICES B

110: ,L_SHIP_METHOD_CODE))
111: INTO L_COUNT
112: FROM
113: WSH_CARRIER_SERVICES A,
114: WSH_ORG_CARRIER_SERVICES B
115: WHERE A.SHIP_METHOD_CODE = L_SHIP_METHOD_CODE
116: AND A.CARRIER_SERVICE_ID = B.CARRIER_SERVICE_ID
117: AND B.ORGANIZATION_ID = NVL(C_DEL_ORG_ID
118: ,P_ORGANIZATION_ID);

Line 131: WSH_ORG_CARRIER_SERVICES B

127: ,L_SHIP_METHOD_CODE)
128: INTO L_CARRIER
129: FROM
130: WSH_CARRIER_SERVICES A,
131: WSH_ORG_CARRIER_SERVICES B
132: WHERE A.SHIP_METHOD_CODE = L_SHIP_METHOD_CODE
133: AND A.CARRIER_SERVICE_ID = B.CARRIER_SERVICE_ID
134: AND B.ORGANIZATION_ID = NVL(C_DEL_ORG_ID
135: ,P_ORGANIZATION_ID);