APPS.GMD_SAMPLES_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 279: WMS_LICENSE_PLATE_NUMBERS WHERE LICENSE_PLATE_NUMBER = p_lpn;

275: -- 7027149
276: cursor get_lpn_no(p_lpn VARCHAR2) is
277: SELECT lpn_id
278: FROM
279: WMS_LICENSE_PLATE_NUMBERS WHERE LICENSE_PLATE_NUMBER = p_lpn;
280:
281: CURSOR get_wms_flag IS
282: SELECT wms_enabled_flag
283: FROM mtl_parameters

Line 290: WMS_LICENSE_PLATE_NUMBERS WHERE lpn_id = p_qc_samples_rec.lpn_id;

286: -- 7027149
287: cursor get_lpn is
288: SELECT 1
289: FROM
290: WMS_LICENSE_PLATE_NUMBERS WHERE lpn_id = p_qc_samples_rec.lpn_id;
291:
292: BEGIN
293:
294: -- Standard Start OF API savepoint