DBA Data[Home] [Help]

APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on WSH_CARRIER_SERVICES

Line 113: WSH_CARRIER_SERVICES A,

109: ,35)
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

Line 130: WSH_CARRIER_SERVICES A,

126: ,35)
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