APPS.MTL_PARAM_VALIDATE_PKG dependencies on DUAL

Line 217: from dual

213: /* Added following query for bug 9945449 */
214:
215: /*select 'uniqueness violated'
216: into v_garbage
217: from dual
218: where exists (select 1 from mtl_serial_numbers a, mtl_serial_numbers b
219: where a.serial_number = b.serial_number
220: and a.current_organization_id <> b.current_organization_id);
221:

Line 247: from dual

243: END;*/
244: BEGIN
245: select 'uniqueness violated'
246: into v_garbage
247: from dual
248: where
249: exists (
250: select serial_number, count(1)
251: from mtl_serial_numbers

Line 259: from dual

255:
256: BEGIN
257: select 'uniqueness violated'
258: into v_garbage
259: from dual
260: where
261: exists (
262: select serial_number, count(1)
263: from mtl_serial_numbers