APPS.PA_PAXARPVD_XMLP_PKG SQL Statements

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

Line: 29

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

Line: 37

      SELECT
        MEANING
      INTO C_YES
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = 'Y';

Line: 44

      SELECT
        MEANING
      INTO C_NO
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = 'N';

Line: 51

      SELECT
        DECODE(P_RUN_VALIDATION
              ,'Y'
              ,C_YES
              ,C_NO),
        DECODE(P_REPORT_ERRORS_ONLY
              ,'Y'
              ,C_YES
              ,C_NO)
      INTO C_RUN_VALIDATION,C_REPORT_ERRORS_ONLY
      FROM
        DUAL;

Line: 73

      SELECT
        BAT.BATCH_NAME,
        BAT.DESCRIPTION,
        BAT.BATCH_STATUS_CODE,
        BAT.TXN_TO_DATE,
        BAT.ACTIVE_CLOSED_FLAG,
        LK.MEANING
      INTO C_BATCH_NAME,C_BATCH_DESCRIPTION,C_BATCH_STATUS,C_THROUGH_DATE,C_BATCH_ACTIVE_CLOSED,C_BATCH_STATUS_MEANING
      FROM
        PA_PURGE_BATCHES BAT,
        PA_LOOKUPS LK
      WHERE PURGE_BATCH_ID = P_PURGE_BATCH_ID
        AND LK.LOOKUP_TYPE = 'PURGE_BATCH_STATUS'
        AND LK.LOOKUP_CODE = BAT.BATCH_STATUS_CODE;

Line: 89

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

Line: 107

    SELECT
      GL.NAME
    INTO L_NAME
    FROM
      GL_SETS_OF_BOOKS GL,
      PA_IMPLEMENTATIONS PI
    WHERE GL.SET_OF_BOOKS_ID = PI.SET_OF_BOOKS_ID;