The following lines contain the word 'select', 'insert', 'update' or 'delete':
select legislation_code
from per_business_groups pbg
where pbg.business_group_id = p_business_group_id;
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => p_assignment_extra_info_id
,p_object_version_number => p_object_version_number
,p_aei_information_category => p_aei_information_category
,p_aei_information1 => p_aei_information1
,p_aei_information2 => p_aei_information2
,p_aei_information3 => p_aei_information3
,p_aei_information4 => p_aei_information4
);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => p_assignment_extra_info_id
,p_object_version_number => p_object_version_number
,p_aei_information_category => p_aei_information_category
,p_aei_information1 => p_aei_information1
,p_aei_information2 => p_aei_information2
,p_aei_information3 => p_aei_information3
,p_aei_information4 => p_aei_information4
,p_aei_information5 => p_aei_information5
,p_aei_information6 => p_aei_information6
,p_aei_information7 => p_aei_information7
);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => p_assignment_extra_info_id
,p_object_version_number => p_object_version_number
,p_aei_information_category => p_aei_information_category
,p_aei_information1 => p_aei_information1
,p_aei_information2 => p_aei_information2
,p_aei_information3 => p_aei_information3
,p_aei_information4 => p_aei_information4
,p_aei_information5 => p_aei_information5
,p_aei_information6 => p_aei_information6
,p_aei_information7 => p_aei_information7
,p_aei_information8 => p_aei_information8
,p_aei_information9 => p_aei_information9
,p_aei_information10 => p_aei_information10
,p_aei_information11 => p_aei_information11
,p_aei_information12 => p_aei_information12
,p_aei_information13 => p_aei_information13
,p_aei_information14 => p_aei_information14
,p_aei_information15 => p_aei_information15
,p_aei_information16 => p_aei_information16
,p_aei_information17 => p_aei_information17
,p_aei_information18 => p_aei_information18
,p_aei_information19 => p_aei_information19
,p_aei_information20 => p_aei_information20
,p_aei_information21 => p_aei_information21
,p_aei_information22 => p_aei_information22
);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => p_assignment_extra_info_id
,p_object_version_number => p_object_version_number
,p_aei_information_category => p_aei_information_category
,p_aei_information1 => p_aei_information1
,p_aei_information2 => p_aei_information2
,p_aei_information3 => p_aei_information3
,p_aei_information4 => p_aei_information4
);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => p_assignment_extra_info_id
,p_object_version_number => p_object_version_number
,p_aei_information_category => p_aei_information_category
,p_aei_information1 => p_aei_information1
,p_aei_information2 => p_aei_information2
,p_aei_information3 => p_aei_information3
,p_aei_information4 => p_aei_information4
,p_aei_information5 => p_aei_information5
,p_aei_information6 => p_aei_information6
);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => p_assignment_extra_info_id
,p_object_version_number => p_object_version_number
,p_aei_information_category => p_aei_information_category
,p_aei_information1 => p_aei_information1
,p_aei_information2 => p_aei_information2
,p_aei_information3 => p_aei_information3
,p_aei_information4 => p_aei_information4
,p_aei_information5 => p_aei_information5
,p_aei_information6 => p_aei_information6
,p_aei_information7 => p_aei_information7
,p_aei_information8 => p_aei_information8
,p_aei_information9 => p_aei_information9
,p_aei_information10 => p_aei_information10
);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => p_assignment_extra_info_id
,p_object_version_number => p_object_version_number
,p_aei_information_category => p_aei_information_category
,p_aei_information1 => p_aei_information1
,p_aei_information2 => p_aei_information2
,p_aei_information3 => p_aei_information3
,p_aei_information4 => p_aei_information4
,p_aei_information5 => p_aei_information5
,p_aei_information6 => p_aei_information6
,p_aei_information7 => p_aei_information7
,p_aei_information8 => p_aei_information8
,p_aei_information9 => p_aei_information9
,p_aei_information10 => p_aei_information10
,p_aei_information11 => p_aei_information11
,p_aei_information12 => p_aei_information12
,p_aei_information13 => p_aei_information13
,p_aei_information14 => p_aei_information14
,p_aei_information15 => p_aei_information15
);