APPS.PO_CONC_MODS_PVT SQL Statements

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

Line: 80

    SELECT modification_number,
      document_id
    INTO l_mod_number,
      l_document_id
    FROM po_drafts
    WHERE draft_id = p_lock_by_draft_id;

Line: 98

  SELECT TO_CHAR(PO_WF_ITEMKEY_S.NEXTVAL)
  INTO l_seq_for_item_key
  FROM sys.dual;

Line: 153

  SELECT  type_lookup_code INTO l_doc_subtype FROM po_headers_all WHERE po_header_id =    l_document_id ;

Line: 159

   , p_mode => 'update');

Line: 162

'UPDATE_MOD_URL' , avalue => l_edit_po_url);