DBA Data[Home] [Help]

APPS.PO_RFQ_VENDORS_PKG_S3 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

  SELECT  1
  INTO    dummy
  FROM    DUAL
  WHERE  not exists (SELECT 1
		     FROM   po_rfq_vendors
		     WHERE  po_header_id = X_po_header_id
                     AND    sequence_num  = X_sequence_num
		     AND    ((X_rowid is null) or
                             (X_rowid != rowid)));
Line: 60

   SELECT nvl(max(sequence_num),0)
   INTO   X_max_sequence_num
   FROM   po_rfq_vendors
   WHERE  po_header_id   = X_po_header_id;