The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE fdr_update_check
( P_PERSON_ID per_all_people_f.person_id%TYPE
, P_DATE_OF_BIRTH date
, P_PER_INFORMATION1 varchar2
, P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '
, P_LAST_NAME per_all_people_f.LAST_NAME%TYPE
, P_EFFECTIVE_DATE date default to_date('01/01/4712','DD/MM/YYYY')
, P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE
, P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE) IS
l_hiredate date;
SELECT count(*)
FROM PER_PEOPLE_EXTRA_INFO
WHERE PERSON_ID = p_csr_person_id
AND INFORMATION_TYPE = 'NL_FIRST_DAY_REPORT'
AND PEI_INFORMATION_CATEGORY = 'NL_FIRST_DAY_REPORT'
AND upper(pei_information2) = 'Y';
SELECT DATE_OF_BIRTH
,PER_INFORMATION1
,PRE_NAME_ADJUNCT
,LAST_NAME
,NATIONAL_IDENTIFIER
,EMPLOYEE_NUMBER
FROM per_all_people_f
WHERE person_id = p_csr_person_id
AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE
AND business_group_id in (SELECT business_group_id
FROM per_business_groups
WHERE legislation_code = 'NL');
END fdr_update_check;
SELECT count(*)
FROM PER_PEOPLE_EXTRA_INFO
WHERE PERSON_ID = p_csr_person_id
AND INFORMATION_TYPE = 'NL_FIRST_DAY_REPORT'
AND PEI_INFORMATION_CATEGORY = 'NL_FIRST_DAY_REPORT'
AND upper(pei_information2) = 'Y';