The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
FULL_NAME
INTO
C_PERSON_NAME
FROM
PER_ALL_PEOPLE_F
WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
AND PERSON_ID = P_PERSON_ID
AND C_EFFECTIVE_DATE between EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE;
SELECT
NAME
INTO
C_BUSINESS_GROUP_NAME
FROM
PER_BUSINESS_GROUPS
WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID;