APPS.PO_REQUISITION_HEADERS_PKG dependencies on DUAL

Line 63: CURSOR S IS SELECT po_requisition_headers_s.nextval FROM sys.dual;

59: CURSOR C IS SELECT rowid FROM PO_REQUISITION_HEADERS
60: WHERE requisition_header_id = X_Requisition_Header_Id;
61:
62:
63: CURSOR S IS SELECT po_requisition_headers_s.nextval FROM sys.dual;
64:
65: /* Ben: bug#465696 Locking the po_unique_identifier_control table at this
66: point of the form commit cycle is causing the performance problem.
67: It may take 5 to 10 seconds to commit a PO with many lines, shipments

Line 335: FROM DUAL

331:
332: x_progress := '010';
333:
334: SELECT 1 INTO dummy
335: FROM DUAL
336: WHERE NOT EXISTS
337: ( SELECT 1
338: FROM po_requisition_headers
339: WHERE Segment1 = X_Segment1