APPS.INV_INVARCPA_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 105: WMS_LICENSE_PLATE_NUMBERS

101: SELECT
102: LICENSE_PLATE_NUMBER
103: INTO M_OUTERMOST_LPN
104: FROM
105: WMS_LICENSE_PLATE_NUMBERS
106: WHERE LPN_ID = OUTERMOST_LPN_ID;
107: EXCEPTION
108: WHEN NO_DATA_FOUND THEN
109: M_OUTERMOST_LPN := 'ERROR';

Line 128: WMS_LICENSE_PLATE_NUMBERS

124: SELECT
125: LICENSE_PLATE_NUMBER
126: INTO M_PARENT_LPN
127: FROM
128: WMS_LICENSE_PLATE_NUMBERS
129: WHERE LPN_ID = PARENT_LPN_ID;
130: EXCEPTION
131: WHEN NO_DATA_FOUND THEN
132: M_PARENT_LPN := 'ERROR';