DBA Data[Home] [Help]

APPS.PO_DOCUMENTS_SV SQL Statements

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

Line: 18

  SELECT podt.type_name
  INTO   x_type_name
  FROM   po_document_types podt
  WHERE  podt.document_type_code = x_doc_type_code
  AND    podt.document_subtype   = x_doc_subtype;
Line: 46

  SELECT podt.security_level_code
  INTO   x_security_level
  FROM   po_document_types podt
  WHERE  podt.document_type_code = x_doc_type_code
  AND    podt.document_subtype   = x_doc_subtype;
Line: 74

  SELECT podt.access_level_code
  INTO   x_access_level
  FROM   po_document_types podt
  WHERE  podt.document_type_code = x_doc_type_code
  AND    podt.document_subtype   = x_doc_subtype;