APPS.PA_PACCGLTR_XMLP_PKG SQL Statements

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

Line: 60

        SELECT
          MEANING
        INTO NDF
        FROM
          PA_LOOKUPS
        WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
          AND LOOKUP_TYPE = 'MESSAGE';

Line: 94

    SELECT
      'Y'
    INTO EXCEP
    FROM
      DUAL
    WHERE exists (
      SELECT
        'yes'
      FROM
        PA_CC_DIST_LINES
      WHERE TRANSFER_STATUS_CODE = 'R'
        AND REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID );

Line: 116

    SELECT
      'Y'
    INTO SUCCESS
    FROM
      DUAL
    WHERE exists (
      SELECT
        'yes'
      FROM
        PA_CC_DIST_LINES
      WHERE TRANSFER_STATUS_CODE = 'A'
        AND REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID );

Line: 139

    SELECT
      GLB.CHART_OF_ACCOUNTS_ID,
      GLB.NAME
    INTO V_DUMMY,V_COMPANY_NAME
    FROM
      GL_SETS_OF_BOOKS GLB,
      PA_IMPLEMENTATIONS IMP
    WHERE GLB.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID;