APPS.PO_COMPLEX_WORK_PVT SQL Statements

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

Line: 107

  SELECT psepi.pay_item_type
  BULK COLLECT INTO l_payment_types_tbl
  FROM po_style_enabled_pay_items psepi
  WHERE psepi.style_id = p_style_id;

Line: 389

  SELECT poh.style_id
  INTO l_style_id
  FROM po_headers_all poh
  WHERE poh.po_header_id = p_po_header_id;

Line: 470

  SELECT poh.style_id
  INTO l_style_id
  FROM po_headers_all poh
  WHERE poh.po_header_id = p_po_header_id;

Line: 596

  SELECT poh.style_id
  INTO l_style_id
  FROM po_headers_all poh
  WHERE poh.po_header_id = p_po_header_id;

Line: 724

    SELECT poll.amount
    INTO l_advance_amount
    FROM po_line_locations_all poll
    WHERE poll.po_line_id = p_po_line_id
      AND poll.payment_type = 'ADVANCE';

Line: 734

    SELECT polla.amount
    INTO l_advance_amount
    FROM po_line_locations_archive_all polla
    WHERE polla.po_line_id = p_po_line_id
      AND polla.revision_num =
            (
               SELECT MAX(polla2.revision_num)
               FROM po_line_locations_archive_all polla2
               WHERE polla2.line_location_id = polla.line_location_id
                 AND polla2.revision_num <= p_doc_revision_num
            )
      AND polla.payment_type = 'ADVANCE';