The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ppf.PERSON_ID
,typ.SYSTEM_PERSON_TYPE
FROM per_all_people_f ppf
,per_person_types typ
,per_person_type_usages_f ptu
WHERE ppf.party_id = p_party_id
AND l_effective_date between ppf.effective_start_date
and ppf.effective_end_date
AND ppf.person_id = ptu.person_id
AND typ.person_type_id = ptu.person_type_id
AND l_effective_date between ptu.effective_start_date
and ptu.effective_end_date
ORDER BY DECODE(typ.system_person_type
,'EMP' ,1
,'CWK' ,2
,'APL' ,3
,'EX_EMP',4
,'EX_CWK',5
,'EX_APL',6
,7
), ppf.person_id desc;
SELECT ppf.PERSON_ID
FROM per_all_people_f ppf
WHERE ppf.party_id = p_party_id
AND l_effective_date between ppf.effective_start_date
and ppf.effective_end_date
AND ppf.person_id <> p_person_id;