APPS.PO_XML_UTILS_GRP SQL Statements

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

Line: 6

  SELECT url INTO x_attachment_content FROM fnd_documents_vl WHERE document_id=p_document_id;

Line: 24

      select short_text into l_short_text
        from fnd_documents_short_text
       where media_id = p_media_id;

Line: 34

      select long_text into l_long_text
        from fnd_documents_long_text
       where media_id = p_media_id;

Line: 62

     select userenv('LANG') into l_lang from dual;

Line: 104

     select pha.segment1 into p_blanket_po_num
     from po_headers_all pha, po_releases_all pra
     where pra.po_header_id = pha.po_header_id and
           pra.po_release_id = p_release_id;

Line: 109

      select segment1 into p_blanket_po_num
      from po_headers_all
      where po_header_id = p_release_id;

Line: 148

   select fnd_global.NEWLINE into l_newline from dual;

Line: 253

select PO_WF_ITEMKEY_S.nextval into l_wf_item_seq from dual;

Line: 260

  select pha.segment1, pha.org_id
  into l_po_number, l_org_id
  from po_releases_all pra, po_headers_all pha
  where pra.po_release_id = p_po_header_id
  and pra.po_header_id = pha.po_header_id;

Line: 268

  select pha.segment1, pha.org_id
  into l_po_number, l_org_id
  from po_headers_all pha
  where pha.po_header_id = p_po_header_id;

Line: 328

l_parameter_list.DELETE;

Line: 346

	select glblH.segment1
	into  x_GLOBALCONTRACT
	from po_headers_all glblH, po_lines_all glblSPO
	where glblSPO.po_line_id = p_po_line_id and
	glblSPO.from_header_id = glblH.po_header_id and
	glblH.global_agreement_flag = 'Y';

Line: 353

	select to_char(glblL.line_Num)
	into x_GLOBALCONTRACTLIN
	from po_lines_all glblL, po_lines_all glblSPO
	where glblSPO.po_line_id = p_po_line_id and
	glblSPO.from_line_id = glblL.po_line_id;

Line: 382

  select po_line_id, TAXABLE_FLAG, ESTIMATED_TAX_AMOUNT
  into   l_po_line_id, l_isTaxable, x_ESTIMATED_TAX_AMOUNT
  from   po_line_locations_archive_all
  where line_location_id = p_po_line_loc_id;

Line: 388

    select TAX_NAME, TYPE_1099, TAX_CODE_ID
    into  x_TAX_NAME, l_type_1099, l_tax_id
    from PO_LINES_ARCHIVE_ALL
    where PO_LINE_ID = l_po_line_id and taxable_flag = 'Y';

Line: 400

    select NAME, TAX_TYPE, DESCRIPTION, TAX_RATE, TAX_RECOVERY_RATE
    into   x_TAX_NAME, x_TAX_TYPE, x_TAX_DESCRIPTION, x_TAX_RATE, l_TAX_RECOVERY_RATE
    from AP_TAX_CODES_ALL
    where tax_id = l_tax_id;

Line: 423

  select TAXABLE_FLAG
  into   X_TAXABLE
  from   po_line_locations_archive_all
  where  line_location_id = p_po_line_loc_id;

Line: 442

  select userenv('lang') into x_lang from dual;