The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
AGREEMENT_ID,
NAME,
DESCRIPTION,
AGREEMENT_NUMBER,
PERSON_ID,
AGREEMENT_START_DATE,
AGREEMENT_END_DATE,
STATUS,
SETA,
PROBATIONARY_END_DATE,
TERMINATED_BY,
LEARNER_TYPE,
REASON_FOR_TERMINATION,
ACTUAL_END_DATE,
AGREEMENT_HARD_COPY_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATED_BY,
CREATION_DATE
from
per_za_learnership_agreements
where
agreement_id = p_agreement_id
for update nowait;