APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on WSH_ORG_CARRIER_SERVICES

Line 99: WSH_ORG_CARRIER_SERVICES B

95: ,L_SHIP_METHOD_CODE))
96: INTO L_COUNT
97: FROM
98: WSH_CARRIER_SERVICES A,
99: WSH_ORG_CARRIER_SERVICES B
100: WHERE A.SHIP_METHOD_CODE = L_SHIP_METHOD_CODE
101: AND A.CARRIER_SERVICE_ID = B.CARRIER_SERVICE_ID
102: AND B.ORGANIZATION_ID = NVL(C_DEL_ORG_ID
103: ,P_ORGANIZATION_ID);

Line 116: WSH_ORG_CARRIER_SERVICES B

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