[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
select SUBSTR(argument1,INSTR(argument1,'=',1)+1,LENGTH(argument1)),
SUBSTR(argument2,INSTR(argument2,'=',1)+1,LENGTH(argument2))
into P_MASS_RECLASS_ID_T,P_REQUEST_ID_T
FROM FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID =P_CONC_REQUEST_ID;
SELECT
SC.COMPANY_NAME
INTO L_COMPANY_NAME
FROM
FA_SYSTEM_CONTROLS SC;
FA_MASS_REC_UTILS_PKG.GET_SELECTION_CRITERIA(X_MASS_RECLASS_ID => P_MASS_RECLASS_ID_T
,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);