APPS.PO_AME_SETUP_PVT SQL Statements

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

Line: 32

  SELECT gls.currency_code
  INTO l_currency_code
  FROM financials_system_params_all fsp,
       gl_sets_of_books gls,
       po_requisition_headers_all prh
  WHERE fsp.set_of_books_id = gls.set_of_books_id and
        fsp.org_id = prh.org_id and       -- 
        prh.requisition_header_id = reqHeaderId;

Line: 74

    SELECT fu.user_id
    INTO l_user_id
    FROM fnd_user fu, po_requisition_headers_all prh
    WHERE prh.requisition_header_id = reqHeaderId and
          prh.preparer_id = fu.employee_id;

Line: 130

  SELECT code_combination_id, set_of_books_id
  INTO l_ccid, l_sob
  FROM po_req_distributions_all
  WHERE distribution_id= distributionId;

Line: 136

  SELECT chart_of_accounts_id
  INTO l_chart_of_accounts_id
  FROM gl_sets_of_books
  WHERE set_of_books_id = l_sob;

Line: 201

  select org_id
  into l_org_id
  from po_requisition_headers_all
  where requisition_header_id = ReqHeaderId;

Line: 210

  SELECT sum(po_calculatereqtotal_pvt.get_req_distribution_total(
              PORL.requisition_header_id,PORL.requisition_line_id,
              PORD.distribution_id))
  into l_req_total
  FROM
       PO_REQ_DISTRIBUTIONS_ALL PORD,  -- 
       PO_REQUISITION_LINES PORL
  WHERE  PORL.requisition_header_id = ReqHeaderId
         AND    PORL.requisition_line_id = PORD.requisition_line_id
         AND    nvl(PORL.cancel_flag, 'N') = 'N'
         AND    nvl(PORL.modified_by_agent_flag, 'N') = 'N';

Line: 256

  select segment1, org_id  into reqNumber, orgId
  from po_requisition_headers_all
  where requisition_header_id =  oldReqHeaderId;

Line: 263

    select requisition_header_id into newReqHeaderId
    from po_requisition_headers_all
    where segment1 = newReqNumber
      and org_id = orgId ;  -- 

Line: 312

    SELECT fu.user_id
    INTO l_user_id
    FROM fnd_user fu, po_requisition_headers_all prh
    WHERE prh.requisition_header_id = reqHeaderId and
          prh.preparer_id = fu.employee_id;

Line: 360

  SELECT NVL(pdt.can_preparer_approve_flag, 'N')
  INTO l_can_approve
  FROM po_document_types_all_b pdt, po_requisition_headers_all prh
  WHERE prh.requisition_header_id = reqHeaderId and
          pdt.org_id = prh.org_id and        -- 
          prh.type_lookup_code = pdt.document_subtype and
          pdt.DOCUMENT_TYPE_CODE='REQUISITION';