DBA Data[Home] [Help]

APPS.WSH_WSHRDVLS_XMLP_PKG dependencies on WSH_NEW_DELIVERIES

Line 59: WSH_NEW_DELIVERIES WND,

55: CURSOR CUR_GET_CONSOL_DELIVERY_NAME(P_PARENT_DELIVERY_LEG_ID IN NUMBER) IS
56: SELECT
57: WND.NAME
58: FROM
59: WSH_NEW_DELIVERIES WND,
60: WSH_DELIVERY_LEGS WDL
61: WHERE WND.DELIVERY_ID = WDL.DELIVERY_ID
62: AND WDL.DELIVERY_LEG_ID = P_PARENT_DELIVERY_LEG_ID;
63: L_CONSOL_DELIVERY_NAME VARCHAR2(30) := NULL;