The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT information_type
FROM per_people_extra_info
WHERE person_extra_info_id = p_person_extra_info_id;
SELECT detail.person_extra_info_id
FROM per_people_extra_info detail
WHERE detail.information_type = 'PER_ABROAD_DETAIL_INFO_CN'
AND p_person_extra_info_id=detail.pei_information1;
SELECT detail.person_extra_info_id
FROM per_people_extra_info detail,per_people_extra_info visa
WHERE detail.information_type = 'PER_ABROAD_DETAIL_INFO_CN'
AND detail.pei_information5 = visa.pei_information1
AND visa.person_extra_info_id = p_person_extra_info_id;
SELECT pei_information1
FROM per_people_extra_info
WHERE information_type = 'PER_ABROAD_MASTER_INFO_CN'
AND person_extra_info_id = p_person_extra_info_id;
SELECT pei_information1
FROM per_people_extra_info
WHERE information_type = 'PER_VISA_INFO_CN'
AND person_extra_info_id = p_person_extra_info_id;