APPS.JA_JAINAR3R_XMLP_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 76: WSH_DELIVERY_ASSIGNMENTS B

72: SELECT
73: A.NAME
74: FROM
75: WSH_NEW_DELIVERIES A,
76: WSH_DELIVERY_ASSIGNMENTS B
77: WHERE A.DELIVERY_ID = B.DELIVERY_ID
78: AND B.DELIVERY_DETAIL_ID = P_DELIVERY_DETAIL_ID;
79: BEGIN
80: OPEN C_DELIVERY_NAME(DELIVERY_DETAIL_ID);

Line 95: WSH_DELIVERY_ASSIGNMENTS B

91: CURSOR C_DELIVERY_NAME(P_DELIVERY_DETAIL_ID IN NUMBER) IS
92: SELECT
93: DELIVERY_ID
94: FROM
95: WSH_DELIVERY_ASSIGNMENTS B
96: WHERE B.DELIVERY_DETAIL_ID = P_DELIVERY_DETAIL_ID;
97: V_DELIVERY_ID NUMBER;
98: BEGIN
99: IF DELIVERY_DETAIL_ID IS NULL THEN