APPS.PO_MOAC_UTILS_PVT SQL Statements

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

Line: 260

     SELECT
     hrou.name
     INTO
     l_ou_name
     FROM
     hr_operating_units hrou
     WHERE
     hrou.organization_id = p_org_id;

Line: 594

    SELECT HROI.ORG_INFORMATION5
    INTO   l_ou_short_code
    FROM   HR_ORGANIZATION_INFORMATION HROI
    WHERE  HROI.ORGANIZATION_ID = p_org_id
      AND  HROI.ORG_INFORMATION_CONTEXT = 'Operating Unit Information';

Line: 719

      select prh.org_id
      into l_org_id
      from po_requisition_headers_all prh
      where prh.requisition_header_id = p_doc_level_id;

Line: 727

      select prl.org_id
      into l_org_id
      from po_requisition_lines_all prl
      where prl.requisition_line_id = p_doc_level_id;

Line: 735

      select prd.org_id
      into l_org_id
      from po_req_distributions_all prd
      where prd.distribution_id = p_doc_level_id;

Line: 751

        SELECT poh.org_id
        INTO l_org_id
        FROM po_headers_all poh
        WHERE poh.po_header_id = p_doc_level_id;

Line: 759

        SELECT por.org_id
        INTO l_org_id
        FROM po_releases_all por
        WHERE por.po_release_id = p_doc_level_id;

Line: 769

      SELECT pol.org_id
      INTO l_org_id
      FROM po_lines_all pol
      WHERE pol.po_line_id = p_doc_level_id;

Line: 777

      SELECT poll.org_id
      INTO l_org_id
      FROM po_line_locations_all poll
      WHERE poll.line_location_id = p_doc_level_id;

Line: 785

      SELECT pod.org_id
      INTO l_org_id
      FROM po_distributions_all pod
      WHERE pod.po_distribution_id = p_doc_level_id;