DBA Data[Home] [Help]

APPS.INV_INVARPMT_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 118: WMS_LICENSE_PLATE_NUMBERS

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

Line 137: WMS_LICENSE_PLATE_NUMBERS

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