The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
NAME
FROM
PER_ORGANIZATION_STRUCTURES
WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
AND NVL(POSITION_CONTROL_STRUCTURE_FLG
,'N') = 'Y';
SELECT
MEANING
FROM
HR_LOOKUPS
WHERE LOOKUP_TYPE = 'PQH_POSITION_TYPE'
AND LOOKUP_CODE = P_POSITION_TYPE;
SELECT
NAME
FROM
FND_CURRENCIES_ACTIVE_V
WHERE CURRENCY_CODE <> 'STAT'
AND CURRENCY_CODE = P_CURRENCY_CODE;
SELECT
sysdate
FROM
DUAL;
SELECT
SYSTEM_TYPE_CD
FROM
PER_SHARED_TYPES
WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID1;
INSERT INTO FND_SESSIONS
(SESSION_ID
,EFFECTIVE_DATE)
VALUES (USERENV('sessionid')
,P_EFFECTIVE_DATE);
SELECT
SYSTEM_TYPE_CD
FROM
PER_SHARED_TYPES
WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID;
SELECT
SYSTEM_TYPE_CD
FROM
PER_SHARED_TYPES
WHERE SHARED_TYPE_ID = BGRP_BUDGET_UNIT_ID;
SELECT
SYSTEM_TYPE_CD
FROM
PER_SHARED_TYPES
WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID
AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
SELECT
SYSTEM_TYPE_CD
FROM
PER_SHARED_TYPES
WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID1
AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
SELECT
SYSTEM_TYPE_CD
FROM
PER_SHARED_TYPES
WHERE SHARED_TYPE_ID = BGRP_BUDGET_UNIT_ID
AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';