APPS.FA_FASRCPVW_XMLP_PKG SQL Statements

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

Line: 5

    SELECT
      FCURR.CURRENCY_CODE
    INTO
      C_CURRENCY_CODE
    FROM
      FA_BOOK_CONTROLS BKCTRL,
      FND_CURRENCIES_VL FCURR,
      GL_SETS_OF_BOOKS GSBKS
    WHERE BKCTRL.BOOK_TYPE_CODE = BOOK
      AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
      AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;

Line: 34

    select SUBSTR(argument1,INSTR(argument1,'=',1)+1,LENGTH(argument1)),
SUBSTR(argument2,INSTR(argument2,'=',1)+1,LENGTH(argument2))
into P_MASS_RECLASS_ID_1,P_REQUEST_ID_1
        from FND_CONCURRENT_REQUESTS
where request_id=P_CONC_REQUEST_ID;

Line: 88

  FUNCTION C_DO_UPDATEFORMULA(C_COUNT IN NUMBER) RETURN NUMBER IS
  BEGIN
    UPDATE
      FA_MASS_RECLASS
    SET
      STATUS = 'PREVIEWED'
    WHERE MASS_RECLASS_ID = P_MASS_RECLASS_ID_1
      AND STATUS = 'PREVIEW';

Line: 98

  END C_DO_UPDATEFORMULA;

Line: 120

    SELECT
      SC.COMPANY_NAME
    INTO
      L_COMPANY_NAME
    FROM
      FA_SYSTEM_CONTROLS SC;

Line: 127

    FA_MASS_REC_UTILS_PKG.GET_SELECTION_CRITERIA(X_MASS_RECLASS_ID => P_MASS_RECLASS_ID_1
                                                ,X_BOOK_TYPE_CODE => BOOK
                                                ,X_ASSET_TYPE => ASSET_TYPE
                                                ,X_FULLY_RSVD => FULLY_RSVD
                                                ,X_FROM_COST => FROM_COST
                                                ,X_TO_COST => TO_COST
                                                ,X_FROM_ASSET => FROM_ASSET
                                                ,X_TO_ASSET => TO_ASSET
                                                ,X_FROM_DPIS => FROM_DPIS
                                                ,X_TO_DPIS => TO_DPIS
                                                ,X_LOCATION => LOCATION
                                                ,X_EMPLOYEE_NAME => EMP_NAME
                                                ,X_EMPLOYEE_NUMBER => EMP_NUM
                                                ,X_OLD_CATEGORY => OLD_CAT
                                                ,X_NEW_CATEGORY => NEW_CAT
                                                ,X_ASSET_KEY => ASSET_KEY
                                                ,X_FROM_EXP_ACCT => FROM_ACCT
                                                ,X_TO_EXP_ACCT => TO_ACCT);