APPS.INV_INVARCTA_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 411: WMS_LICENSE_PLATE_NUMBERS

407: SELECT
408: LICENSE_PLATE_NUMBER
409: INTO X_OUTERMOST_LPN
410: FROM
411: WMS_LICENSE_PLATE_NUMBERS
412: WHERE LPN_ID = OUTERMOST_LPN_ID;
413: EXCEPTION
414: WHEN NO_DATA_FOUND THEN
415: X_OUTERMOST_LPN := 'ERROR';

Line 432: WMS_LICENSE_PLATE_NUMBERS

428: SELECT
429: LICENSE_PLATE_NUMBER
430: INTO X_PARENT_LPN
431: FROM
432: WMS_LICENSE_PLATE_NUMBERS
433: WHERE LPN_ID = PARENT_LPN_ID;
434: EXCEPTION
435: WHEN NO_DATA_FOUND THEN
436: X_PARENT_LPN := 'ERROR';