DBA Data[Home] [Help]

APPS.PO_HEADERS_PKG_S2 dependencies on DUAL

Line 331: from sys.dual

327: X_progress := '010';
328:
329: SELECT 'no duplicates'
330: into X_dummy
331: from sys.dual
332: where not exists
333: (SELECT 'po number is not unique'
334: FROM po_headers ph
335: WHERE ph.segment1 = X_segment1

Line 344: from sys.dual

340: X_Progress := '020';
341:
342: SELECT 'no duplicates'
343: into X_dummy
344: from sys.dual
345: where not exists
346: (SELECT 'po number is not unique'
347: FROM po_history_pos ph
348: WHERE ph.segment1 = X_segment1

Line 388: from sys.dual

384: X_progress := '050';
385:
386: SELECT 'no duplicates'
387: into X_dummy
388: from sys.dual
389: where not exists
390: (SELECT 'rfq/quote number is not unique'
391: FROM po_headers ph
392: WHERE ph.segment1 = X_segment1

Line 400: from sys.dual

396: X_Progress := '060';
397:
398: SELECT 'no duplicates'
399: into X_dummy
400: from sys.dual
401: where not exists
402: (SELECT 'rfq/quote number is not unique'
403: FROM po_history_pos ph
404: WHERE ph.segment1 = X_segment1