APPS.JA_JAINAPCR_XMLP_PKG SQL Statements

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

Line: 7

    SELECT
      PO_HEADER_ID
    INTO V_PO_HEADER_ID
    FROM
      PO_DISTRIBUTIONS_ALL
    WHERE PO_DISTRIBUTION_ID = P_PO_DISTRIBUTION_ID;

Line: 13

    SELECT
      SEGMENT1
    INTO V_PO_NUM
    FROM
      PO_HEADERS_ALL
    WHERE PO_HEADER_ID = V_PO_HEADER_ID;

Line: 32

    SELECT
      PO_HEADER_ID
    INTO V_PO_HEADER_ID
    FROM
      PO_DISTRIBUTIONS_ALL
    WHERE PO_DISTRIBUTION_ID = P_PO_DISTRIBUTION_ID;

Line: 38

    SELECT
      SHIP_TO_LOCATION_ID
    INTO V_SHIP_TO_LOCATION_ID
    FROM
      PO_HEADERS_ALL
    WHERE PO_HEADER_ID = V_PO_HEADER_ID;

Line: 44

    SELECT
      INVENTORY_ORGANIZATION_ID
    INTO V_ORGANIZATION_ID
    FROM
      HR_LOCATIONS
    WHERE LOCATION_ID = V_SHIP_TO_LOCATION_ID;

Line: 50

    SELECT
      ORGANIZATION_NAME
    INTO V_ORGANIZATION_NAME
    FROM
      ORG_ORGANIZATION_DEFINITIONS
    WHERE ORGANIZATION_ID = V_ORGANIZATION_ID;

Line: 68

      SELECT
        LOCATION_CODE
      FROM
        HR_LOCATIONS HL,
        PO_HEADERS_ALL PH,
        PO_DISTRIBUTIONS_ALL POD
      WHERE PH.PO_HEADER_ID = POD.PO_HEADER_ID
        AND POD.PO_DISTRIBUTION_ID = P_PO_DISTRIBUTION_ID
        AND HL.LOCATION_ID = PH.SHIP_TO_LOCATION_ID;

Line: 96

    SELECT
      SET_OF_BOOKS_ID
    INTO V_SET_OF_BOOKS_ID
    FROM
      HR_OPERATING_UNITS
    WHERE ORGANIZATION_ID = NVL(ORG_ID
       ,0);

Line: 103

    SELECT
      CURRENCY_CODE
    INTO V_FUNCTIONAL_CURRENCY
    FROM
      GL_SETS_OF_BOOKS
    WHERE SET_OF_BOOKS_ID = V_SET_OF_BOOKS_ID;

Line: 152

    SELECT
      SET_OF_BOOKS_ID
    INTO V_SET_OF_BOOKS_ID
    FROM
      HR_OPERATING_UNITS
    WHERE ORGANIZATION_ID = NVL(ORG_ID
       ,0);

Line: 159

    SELECT
      CURRENCY_CODE
    INTO V_FUNCTIONAL_CURRENCY
    FROM
      GL_SETS_OF_BOOKS
    WHERE SET_OF_BOOKS_ID = V_SET_OF_BOOKS_ID;

Line: 195

    SELECT
      BATCH_NAME
    INTO V_BATCH_NAME
    FROM
      AP_BATCHES_ALL
    WHERE BATCH_ID = P_BATCH_ID;

Line: 212

    SELECT
      DISTINCT
      SET_OF_BOOKS_ID
    INTO V_SET_OF_BOOKS_ID
    FROM
      AP_INVOICES_ALL
    WHERE INVOICE_NUM = P_INVOICE_NUM;

Line: 219

    SELECT
      NAME
    INTO V_NAME
    FROM
      GL_SETS_OF_BOOKS_V
    WHERE SET_OF_BOOKS_ID = V_SET_OF_BOOKS_ID;

Line: 248

    SELECT
      VENDOR_ID
    INTO V_VENDOR_ID
    FROM
      PO_VENDORS
    WHERE SEGMENT1 = V_SEGMENT2;

Line: 254

    SELECT
      SET_OF_BOOKS_ID
    INTO V_SET_OF_BOOKS_ID
    FROM
      HR_OPERATING_UNITS
    WHERE ORGANIZATION_ID = NVL(V_ORG_ID1
       ,0);

Line: 261

    SELECT
      CURRENCY_CODE
    INTO V_FUNCTIONAL_CURRENCY
    FROM
      GL_SETS_OF_BOOKS
    WHERE SET_OF_BOOKS_ID = V_SET_OF_BOOKS_ID;

Line: 291

    SELECT
      VENDOR_ID
    INTO V_VENDOR_ID
    FROM
      PO_VENDORS
    WHERE SEGMENT1 = V_SEGMENT2;

Line: 297

    SELECT
      SET_OF_BOOKS_ID
    INTO V_SET_OF_BOOKS_ID
    FROM
      HR_OPERATING_UNITS
    WHERE ORGANIZATION_ID = NVL(V_ORG_ID1
       ,0);

Line: 323

      SELECT
        VENDOR_NAME
      FROM
        PO_VENDORS
      WHERE VENDOR_ID = V_ID
      OR SEGMENT1 = V_NO;

Line: 339

      SELECT
        SET_OF_BOOKS_ID
      FROM
        HR_OPERATING_UNITS
      WHERE ORGANIZATION_ID = ORG_ID;

Line: 345

      SELECT
        NAME
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = SOB_ID;

Line: 481

      SELECT
        CONCURRENT_PROGRAM_ID,
        NVL(ENABLE_TRACE
           ,'N')
      FROM
        FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = P_REQUEST_ID;

Line: 491

      SELECT
        A.SID,
        A.SERIAL#,
        B.SPID
      FROM
        V$SESSION A,
        V$PROCESS B
      WHERE AUDSID = USERENV('SESSIONID')
        AND A.PADDR = B.ADDR;

Line: 501

      SELECT
        NAME
      FROM
        V$DATABASE;