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;
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
,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 -- Bug 6994632 added for Prev Tax Pay Notified
);
select legislation_code
from per_business_groups pbg
where pbg.business_group_id = p_business_group_id;
select per_information10
from per_all_people_f
where person_id = c_person_id
and c_effective_date between
effective_start_date and effective_end_date;
SELECT hsck.segment1, period_of_service_id
FROM hr_soft_coding_keyflex hsck,
pay_all_payrolls_f papf,
per_all_assignments_f paaf
WHERE hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
AND papf.payroll_id = paaf.payroll_id
AND paaf.assignment_id = c_assignment_id
AND c_effective_date between
papf.effective_start_date and papf.effective_end_date
AND c_effective_date between
paaf.effective_start_date and paaf.effective_end_date;
select distinct
a.assignment_id,
extra.assignment_extra_info_id,
extra.object_version_number ovn,
extra.aei_information_category,
extra.aei_information1,
extra.aei_information2,
extra.aei_information3,
extra.aei_information4
from per_all_assignments_f a,
pay_all_payrolls_f pay,
hr_soft_coding_keyflex flex,
per_assignment_status_types past,
per_assignment_extra_info extra
where a.person_id = c_person_id
and flex.segment1 = c_tax_ref
and pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
and a.payroll_id = pay.payroll_id
and a.assignment_status_type_id = past.assignment_status_type_id
and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
and a.period_of_service_id = c_period_of_service_id
and c_effective_date between
pay.effective_start_date and pay.effective_end_date
and a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_effective_date)
and a.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_ref, c_effective_date)
and extra.assignment_id(+) = a.assignment_id
and extra.information_type(+) = p_information_type
and a.assignment_id <> c_assignment_id
;
select max(effective_end_date)
from per_all_assignments_f a,
per_assignment_status_types past
where a.assignment_id = c_assignment_id
and a.assignment_status_type_id = past.assignment_status_type_id
and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
select max(effective_end_date) + 1
from per_all_people_f
where person_id = c_person_id
and nvl(per_information10,'N') = 'N'
and effective_end_date < c_effective_date;
select 1
from per_all_assignments_f a
where a.assignment_id = c_assignment_id
and a.effective_end_date >= c_start_date
and a.effective_start_date <= c_end_date;
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => r_rec.assignment_extra_info_id
,p_object_version_number => l_object_version_number
,p_aei_information_category => r_rec.aei_information_category
,p_aei_information1 => r_rec.aei_information1
,p_aei_information2 => r_rec.aei_information2
,p_aei_information3 => p_aei_information3
,p_aei_information4 => r_rec.aei_information4);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => r_rec.assignment_extra_info_id
,p_object_version_number => l_object_version_number
,p_aei_information_category => r_rec.aei_information_category
,p_aei_information1 => r_rec.aei_information1
,p_aei_information2 => r_rec.aei_information2
,p_aei_information3 => r_rec.aei_information3
,p_aei_information4 => p_aei_information4);
select legislation_code
from per_business_groups pbg
where pbg.business_group_id = p_business_group_id;
select per_information10
from per_all_people_f
where person_id = c_person_id
and c_effective_date between
effective_start_date and effective_end_date;
select aei_information3, aei_information4, information_type
from per_assignment_extra_info
where assignment_extra_info_id = c_assignment_extra_info_id;
SELECT hsck.segment1, period_of_service_id
FROM hr_soft_coding_keyflex hsck,
pay_all_payrolls_f papf,
per_all_assignments_f paaf
WHERE hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
AND papf.payroll_id = paaf.payroll_id
AND paaf.assignment_id = c_assignment_id
AND c_effective_date between
papf.effective_start_date and papf.effective_end_date
AND c_effective_date between
paaf.effective_start_date and paaf.effective_end_date;
select distinct
a.assignment_id,
extra.assignment_extra_info_id,
extra.object_version_number ovn,
extra.aei_information_category,
extra.aei_information1,
extra.aei_information2,
extra.aei_information3,
extra.aei_information4
from per_all_assignments_f a,
pay_all_payrolls_f pay,
hr_soft_coding_keyflex flex,
per_assignment_status_types past,
per_assignment_extra_info extra
where a.person_id = c_person_id
and flex.segment1 = c_tax_ref
and pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
and a.payroll_id = pay.payroll_id
and extra.assignment_id(+) = a.assignment_id
and extra.information_type(+) = c_information_type
and a.assignment_status_type_id = past.assignment_status_type_id
and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
and a.period_of_service_id = c_period_of_service_id
and c_effective_date between
pay.effective_start_date and pay.effective_end_date
and a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_effective_date)
and a.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_ref, c_effective_date)
and a.assignment_id <> c_assignment_id
;
select max(effective_end_date)
from per_all_assignments_f a,
per_assignment_status_types past
where a.assignment_id = c_assignment_id
and a.assignment_status_type_id = past.assignment_status_type_id
and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
select max(effective_end_date) + 1
from per_all_people_f
where person_id = c_person_id
and nvl(per_information10,'N') = 'N'
and effective_end_date < c_effective_date;
select 1
from per_all_assignments_f a
where a.assignment_id = c_assignment_id
and a.effective_end_date >= c_start_date
and a.effective_start_date <= c_end_date;
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 => r_rec.assignment_extra_info_id
,p_object_version_number => l_object_version_number
,p_aei_information_category => r_rec.aei_information_category
,p_aei_information1 => r_rec.aei_information1
,p_aei_information2 => r_rec.aei_information2
,p_aei_information3 => null
,p_aei_information4 => r_rec.aei_information4);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => r_rec.assignment_extra_info_id
,p_object_version_number => l_object_version_number
,p_aei_information_category => r_rec.aei_information_category
,p_aei_information1 => r_rec.aei_information1
,p_aei_information2 => r_rec.aei_information2
,p_aei_information3 => p_aei_information3
,p_aei_information4 => r_rec.aei_information4);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => r_rec.assignment_extra_info_id
,p_object_version_number => l_object_version_number
,p_aei_information_category => r_rec.aei_information_category
,p_aei_information1 => r_rec.aei_information1
,p_aei_information2 => r_rec.aei_information2
,p_aei_information3 => r_rec.aei_information3
,p_aei_information4 => null);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => r_rec.assignment_extra_info_id
,p_object_version_number => l_object_version_number
,p_aei_information_category => r_rec.aei_information_category
,p_aei_information1 => r_rec.aei_information1
,p_aei_information2 => r_rec.aei_information2
,p_aei_information3 => r_rec.aei_information3
,p_aei_information4 => p_aei_information4);
select legislation_code
from per_business_groups pbg
where pbg.business_group_id = p_business_group_id;
select per_information10
from per_all_people_f
where person_id = c_person_id
and c_effective_date between
effective_start_date and effective_end_date;
select aei_information3, aei_information4, information_type, assignment_id
from per_assignment_extra_info
where assignment_extra_info_id = c_assignment_extra_info_id;
SELECT hsck.segment1, period_of_service_id, person_id
FROM hr_soft_coding_keyflex hsck,
pay_all_payrolls_f papf,
per_all_assignments_f paaf
WHERE hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
AND papf.payroll_id = paaf.payroll_id
AND paaf.assignment_id = c_assignment_id
AND c_effective_date between
papf.effective_start_date and papf.effective_end_date
AND c_effective_date between
paaf.effective_start_date and paaf.effective_end_date;
select distinct
a.assignment_id,
extra.assignment_extra_info_id,
extra.object_version_number ovn,
extra.aei_information_category,
extra.aei_information1,
extra.aei_information2,
extra.aei_information3,
extra.aei_information4
from per_all_assignments_f a,
pay_all_payrolls_f pay,
hr_soft_coding_keyflex flex,
per_assignment_status_types past,
per_assignment_extra_info extra
where a.person_id = c_person_id
and flex.segment1 = c_tax_ref
and pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
and a.payroll_id = pay.payroll_id
and extra.assignment_id(+) = a.assignment_id
and extra.information_type(+) = c_information_type
and a.assignment_status_type_id = past.assignment_status_type_id
and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
and a.period_of_service_id = c_period_of_service_id
and c_effective_date between
pay.effective_start_date and pay.effective_end_date
and a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_effective_date)
and a.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_ref, c_effective_date)
and a.assignment_id <> c_assignment_id
;
select max(effective_end_date)
from per_all_assignments_f a,
per_assignment_status_types past
where a.assignment_id = c_assignment_id
and a.assignment_status_type_id = past.assignment_status_type_id
and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
select max(effective_end_date) + 1
from per_all_people_f
where person_id = c_person_id
and nvl(per_information10,'N') = 'N'
and effective_end_date < c_effective_date;
select 1
from per_all_assignments_f a
where a.assignment_id = c_assignment_id
and a.effective_end_date >= c_start_date
and a.effective_start_date <= c_end_date;
hr_assignment_extra_info_api.delete_assignment_extra_info
(p_validate => false,
p_assignment_extra_info_id => p_assignment_extra_info_id,
p_object_version_number => p_object_version_number);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => r_rec.assignment_extra_info_id
,p_object_version_number => l_object_version_number
,p_aei_information_category => r_rec.aei_information_category
,p_aei_information1 => r_rec.aei_information1
,p_aei_information2 => r_rec.aei_information2
,p_aei_information3 => null
,p_aei_information4 => r_rec.aei_information4);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => p_validate
,p_assignment_extra_info_id => r_rec.assignment_extra_info_id
,p_object_version_number => l_object_version_number
,p_aei_information_category => r_rec.aei_information_category
,p_aei_information1 => r_rec.aei_information1
,p_aei_information2 => r_rec.aei_information2
,p_aei_information3 => r_rec.aei_information3
,p_aei_information4 => null);
select legislation_code
from per_business_groups pbg
where pbg.business_group_id = p_business_group_id;
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
,p_aei_information5 => p_aei_information5
,p_aei_information6 => p_aei_information6
);
select legislation_code
from per_business_groups pbg
where pbg.business_group_id = p_business_group_id;
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
,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);