The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
P.BASE_CURRENCY_CODE,
C.PRECISION,
C.MINIMUM_ACCOUNTABLE_UNIT,
C.DESCRIPTION
INTO
BASE_CURR
,PREC
,MIN_AU
,DESCR
FROM
AP_SYSTEM_PARAMETERS P,
FND_CURRENCIES_VL C
WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE;
SELECT
LY.MEANING,
LN.MEANING,
LA.DISPLAYED_FIELD
INTO
NLS_YES
,NLS_NO
,NLS_ALL
FROM
FND_LOOKUPS LY,
FND_LOOKUPS LN,
AP_LOOKUP_CODES LA
WHERE LY.LOOKUP_TYPE = 'YES_NO'
AND LY.LOOKUP_CODE = 'Y'
AND LN.LOOKUP_TYPE = 'YES_NO'
AND LN.LOOKUP_CODE = 'N'
AND LA.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
AND LA.LOOKUP_CODE = 'ALL';
SELECT
SUBSTR(L.ADDRESS_LINE_1
,1
,35),
SUBSTR(L.ADDRESS_LINE_2
,1
,35),
SUBSTR(L.ADDRESS_LINE_3
,1
,35),
SUBSTR(L.TOWN_OR_CITY
,1
,30),
SUBSTR(NVL(L.REGION_3
,L.REGION_2)
,1
,30),
SUBSTR(L.POSTAL_CODE
,1
,20)
INTO
FROM_ADDRESS_LINE1
,FROM_ADDRESS_LINE2
,FROM_ADDRESS_LINE3
,FROM_CITY
,FROM_STATE
,FROM_ZIP
FROM
HR_LOCATIONS L
WHERE L.LOCATION_ID = P_LOCATION_ID;
SELECT
NAME,
CHART_OF_ACCOUNTS_ID
INTO
L_NAME
,L_CHART_OF_ACCOUNTS_ID
FROM
GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID = L_SOB_ID;
SELECT
TO_CHAR(SYSDATE
,'fmMonth DD, YYYY')
INTO
L_CURDATE
FROM
DUAL;
SELECT
SUBSTR(USERENV('LANGUAGE')
,1
,INSTR(USERENV('LANGUAGE')
,'_') - 1)
INTO
SESSION_LANGUAGE
FROM
DUAL;
SELECT
NLS_LANGUAGE
INTO
BASE_LANGUAGE
FROM
FND_LANGUAGES
WHERE INSTALLED_FLAG = 'B';