APPS.INV_INVARPAR_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 161: WMS_LICENSE_PLATE_NUMBERS

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

Line 181: WMS_LICENSE_PLATE_NUMBERS

177: SELECT
178: LICENSE_PLATE_NUMBER
179: INTO M_PARENT_LPN
180: FROM
181: WMS_LICENSE_PLATE_NUMBERS
182: WHERE LPN_ID = P_PARENT_LPN_ID;
183: EXCEPTION
184: WHEN NO_DATA_FOUND THEN
185: M_PARENT_LPN := 'ERROR';