APPS.PO_DRILLDOWN_PUB_PKG SQL Statements

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

Line: 161

      SELECT nvl(FEDERAL_FLAG,'N')
      INTO   l_federal_flag
      FROM po_requisition_headers_all
      WHERE requisition_header_id = p_source_id_int_1;

Line: 182

      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: 192

        p_parameters          := '/OA_HTML/OA.jsp?OAFunc=PO_ORDER'||'&'||'poHeaderId=' || to_char(l_document_id)||'&'||'poMode=viewOnly'||'&'||'poHideUpdate=Y';

Line: 196

        p_parameters          := '/OA_HTML/OA.jsp?OAFunc=PO_BLANKET'||'&'||'poHeaderId=' || to_char(l_document_id)||'&'||'poMode=viewOnly'||'&'||'poHideUpdate=Y';

Line: 206

        select po_header_id
        into l_bpa_header_id
        from po_releases_all
        where po_release_id=l_document_id;