The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
NAME
FROM
PER_JOBS_VL
WHERE JOB_ID = JOB_ID
AND BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
AND sysdate between NVL(DATE_FROM
,SYSDATE)
AND NVL(DATE_TO
,SYSDATE);
SELECT
MEANING
FROM
HR_LOOKUPS
WHERE LOOKUP_TYPE = 'PQH_ACADEMIC_RANK'
AND LOOKUP_CODE = RANK_ID;
SELECT
MEANING
FROM
HR_LOOKUPS
WHERE LOOKUP_TYPE = 'PQH_TENURE_STATUS'
AND LOOKUP_CODE = TENURE_STATUS_CD;
SELECT
LAST_NAME || ', ' || FIRST_NAME
FROM
PER_ALL_PEOPLE_F
WHERE PERSON_ID = P_MANAGER_ID
AND sysdate between EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE;