APPS.FA_FASRVPVW_XMLP_PKG SQL Statements

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

Line: 21

    select  SUBSTR(ARGUMENT1,INSTR(ARGUMENT1,'=',1,1)+1) into P_MASS_REVAL_ID1
FROM FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID =P_CONC_REQUEST_ID;

Line: 25

    SELECT
      BOOK_TYPE_CODE
    INTO L_BOOK
    FROM
      FA_MASS_REVALUATIONS
    WHERE MASS_REVAL_ID = P_MASS_REVAL_ID1;

Line: 174

    UPDATE
      FA_MASS_REVALUATIONS
    SET
      STATUS = 'PREVIEWED'
    WHERE MASS_REVAL_ID = P_MASS_REVAL_ID1;

Line: 179

    DELETE FROM FA_MASS_REVAL_REP_ITF
     WHERE MASS_REVAL_ID = P_MASS_REVAL_ID1
       AND REQUEST_ID = P_CONC_REQUEST_ID;

Line: 206

      SELECT
        CP.USER_CONCURRENT_PROGRAM_NAME
      INTO L_REPORT_NAME
      FROM
        FND_CONCURRENT_PROGRAMS_VL CP,
        FND_CONCURRENT_REQUESTS CR
      WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
        AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
        AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;

Line: 237

      SELECT
        MR.DESCRIPTION,
        MR.BOOK_TYPE_CODE,
        MR.DEFAULT_REVAL_FULLY_RSVD_FLAG,
        MR.DEFAULT_LIFE_EXTENSION_FACTOR,
        MR.DEFAULT_LIFE_EXTENSION_CEILING,
        MR.DEFAULT_MAX_FULLY_RSVD_REVALS,
        SOB.CURRENCY_CODE
      INTO L_DESCRIPTION,L_BOOK_TYPE_CODE,TEMP_DEFAULT_RFRF,L_DEFAULT_LEF,L_DEFAULT_LEC,L_DEFAULT_MFRR,L_CURRENCY_CODE
      FROM
        FA_MASS_REVALUATIONS MR,
        FA_BOOK_CONTROLS BC,
        GL_SETS_OF_BOOKS SOB
      WHERE MR.MASS_REVAL_ID = P_MASS_REVAL_ID1
        AND MR.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
        AND BC.DATE_INEFFECTIVE is null
        AND SOB.SET_OF_BOOKS_ID = BC.SET_OF_BOOKS_ID;

Line: 254

      SELECT
        MEANING
      INTO L_DEFAULT_RFRF
      FROM
        FA_LOOKUPS
      WHERE LOOKUP_TYPE = 'YESNO'
        AND LOOKUP_CODE = NVL(TEMP_DEFAULT_RFRF
         ,'NO');