DBA Data[Home] [Help]

APPS.INV_INVARPMT_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 119: WMS_LICENSE_PLATE_NUMBERS

115: SELECT
116: LICENSE_PLATE_NUMBER
117: INTO M_OUTERMOST_LPN
118: FROM
119: WMS_LICENSE_PLATE_NUMBERS
120: WHERE LPN_ID = P_OUTERMOST_LPN_ID;
121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN
123: M_OUTERMOST_LPN := 'ERROR';

Line 139: WMS_LICENSE_PLATE_NUMBERS

135: SELECT
136: LICENSE_PLATE_NUMBER
137: INTO M_PARENT_LPN
138: FROM
139: WMS_LICENSE_PLATE_NUMBERS
140: WHERE LPN_ID = P_PARENT_LPN_ID;
141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN
143: M_PARENT_LPN := 'ERROR';