The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT global_value
FROM ff_globals_f
WHERE global_name = 'IN_PTAX_CEILING'
AND p_effective_date between effective_start_date and effective_end_date;
SELECT 'X'
FROM per_person_types ppt,
per_person_type_usages_f pptu
WHERE ppt.person_type_id = pptu.person_type_id
AND ppt.business_group_id = p_business_group_id
AND pptu.person_id = p_person_id
AND p_effective_date BETWEEN pptu.effective_start_date
AND pptu.effective_end_date AND ppt.system_person_type = 'EMP';
PROCEDURE check_prev_emp_update(
p_effective_date IN DATE
,p_previous_employer_id IN NUMBER
,p_start_date IN DATE
,p_end_date IN DATE
,p_pem_information_category IN VARCHAR2
,p_pem_information1 IN VARCHAR2
,p_pem_information2 IN VARCHAR2
,p_pem_information3 IN VARCHAR2
,p_pem_information4 IN VARCHAR2
,p_pem_information5 IN VARCHAR2
,p_pem_information6 IN VARCHAR2
,p_pem_information7 IN VARCHAR2
,p_pem_information8 IN VARCHAR2
,p_pem_information9 IN VARCHAR2
,p_pem_information10 IN VARCHAR2
,p_pem_information11 IN VARCHAR2
,p_pem_information12 IN VARCHAR2
,p_pem_information13 IN VARCHAR2
,p_pem_information14 IN VARCHAR2
,p_pem_information15 IN VARCHAR2
,p_pem_information16 IN VARCHAR2
,p_pem_information17 IN VARCHAR2
,p_pem_information18 IN VARCHAR2
,p_pem_information19 IN VARCHAR2
,p_pem_information20 IN VARCHAR2
,p_pem_information21 IN VARCHAR2
,p_pem_information22 IN VARCHAR2
,p_pem_information23 IN VARCHAR2
,p_pem_information24 IN VARCHAR2
,p_pem_information25 IN VARCHAR2
,p_pem_information26 IN VARCHAR2
,p_pem_information27 IN VARCHAR2
,p_pem_information28 IN VARCHAR2
,p_pem_information29 IN VARCHAR2
,p_pem_information30 IN VARCHAR2)
IS
CURSOR c_pem_id IS
SELECT business_group_id
,person_id
,start_date
,end_date
,pem_information_category
,pem_information1
,pem_information2
,pem_information3
,pem_information4
,pem_information5
,pem_information6
,pem_information7
,pem_information8
,pem_information9
,pem_information10
,pem_information11
,pem_information12
,pem_information13
,pem_information14
,pem_information15
,pem_information16
,pem_information17
,pem_information18
,pem_information19
,pem_information20
,pem_information21
,pem_information22
,pem_information23
,pem_information24
,pem_information25
,pem_information26
,pem_information27
,pem_information28
,pem_information29
,pem_information30
FROM per_previous_employers
WHERE previous_employer_id = p_previous_employer_id;
l_procedure := g_package||'check_prev_emp_update';
END check_prev_emp_update;