DBA Data[Home] [Help]

APPS.PO_DRILLDOWN_PUB_PKG SQL Statements

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

Line: 163

      SELECT nvl(global_agreement_flag,'N'),
             type_lookup_code
      INTO   l_global_agreement_flag,
             l_document_subtype
      FROM po_headers_all
      WHERE po_header_id=p_source_id_int_1;
Line: 187

        select po_header_id
        into l_bpa_header_id
        from po_releases_all
        where po_release_id=l_document_id;