APPS.INV_INVARPAR_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 159: WMS_LICENSE_PLATE_NUMBERS

155: SELECT
156: LICENSE_PLATE_NUMBER
157: INTO M_OUTERMOST_LPN
158: FROM
159: WMS_LICENSE_PLATE_NUMBERS
160: WHERE LPN_ID = OUTERMOST_LPN_ID;
161: EXCEPTION
162: WHEN NO_DATA_FOUND THEN
163: M_OUTERMOST_LPN := 'ERROR';

Line 178: WMS_LICENSE_PLATE_NUMBERS

174: SELECT
175: LICENSE_PLATE_NUMBER
176: INTO M_PARENT_LPN
177: FROM
178: WMS_LICENSE_PLATE_NUMBERS
179: WHERE LPN_ID = PARENT_LPN_ID;
180: EXCEPTION
181: WHEN NO_DATA_FOUND THEN
182: M_PARENT_LPN := 'ERROR';