The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
PPF.LAST_NAME,
NVL(PPF.EMPLOYEE_NUMBER
,PPF.NPW_NUMBER) EMPLOYEE_NUMBER
FROM
PER_PEOPLE_F PPF
WHERE PPF.PERSON_ID = CP_PERSON_ID
AND CP_EFFECTIVE_DATE between PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE;
SELECT
HRP.NAME
FROM
HXC_RETRIEVAL_PROCESSES HRP
WHERE HRP.RETRIEVAL_PROCESS_ID = CP_RETRIEVAL_PROCESS_ID;
SELECT
RP.RETRIEVAL_PROCESS_ID
FROM
HXC_RETRIEVAL_PROCESSES RP
WHERE NAME = 'BEE Retrieval Process';