The following lines contain the word 'select', 'insert', 'update' or 'delete':
'SELECT DECODE(:REFERENCE,''INCRSE'',''Princ. Incr'',''Repayment'') INTO :REF_TYPE FROM DUAL';
SELECT DECODE(REFERENCE,'INCRSE','Princ. Incr','Repayment') INTO REF_TYPE FROM DUAL;
'SELECT DECODE(:REFERENCE,''DEDUCTION'',:ADJUST_PRINCIPAL,0) INTO :PRIN_DED FROM DUAL';
SELECT DECODE(REFERENCE,'DEDUCTION',ADJUST_PRINCIPAL,0) INTO PRIN_DED FROM DUAL;
'SELECT (nvl(:ADJUST_INTEREST,0) + nvl(:ADJUST_PRIN,0)) INTO :PI_RECD FROM DUAL';
SELECT (nvl(ADJUST_INTEREST,0) + nvl(ADJUST_PRIN,0)) INTO PI_RECD FROM DUAL;
'SELECT DECODE(:REFERENCE,''DEDUCTION'',:ADJUST_PRINCIPAL,:ADJUST_PRINCIPAL) INTO :ADJUST_PRIN FROM DUAL';
SELECT DECODE(REFERENCE,'DEDUCTION',ADJUST_PRINCIPAL,ADJUST_PRINCIPAL) INTO ADJUST_PRIN FROM DUAL;
'SELECT DECODE(:REFERENCE,''INCRSE'',:BALANCE_CFWD - NVL(:PRIN_DECRSE,0),:BALANCE_CFWD) INTO :ACTUAL_BAL FROM DUAL';
SELECT DECODE(REFERENCE,'INCRSE',BALANCE_CFWD - NVL(PRIN_DECRSE,0),BALANCE_CFWD) INTO ACTUAL_BAL FROM DUAL;
'SELECT nvl(:INTEREST_DUE,0) + nvl(:BALANCE_DUE,0) INTO :NET_DUE from DUAL';
SELECT nvl(INTEREST_DUE,0) + nvl(BALANCE_DUE,0) INTO NET_DUE from DUAL;
SELECT
SUBSTR(USER
,1
,10)
INTO
CP_PARA
FROM
DUAL;
SELECT
ITEM_NAME,
SUBSTR(TEXT
,1
,100) LANG_NAME
FROM
XTR_SYS_LANGUAGES_VL
WHERE MODULE_NAME = P_MODULE;
SELECT
CP.USER_CONCURRENT_PROGRAM_NAME
INTO
REPORT_SHORT_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;