[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select adr.address_id,
adr.object_version_number,
paf.business_group_id as bg_id
from per_addresses adr, per_all_people_f paf
where paf.party_id = adr.party_id
and paf.person_id = p_person_id
and adr.person_id is null
and p_effective_date between paf.effective_start_date and paf.effective_end_date;
select phn.phone_id,
phn.object_version_number
from per_phones phn, per_all_people_f paf
where phn.party_id=paf.party_id
and paf.person_id = p_person_id
and phn.parent_id is null
and p_effective_date between paf.effective_start_date and paf.effective_end_date;
select pem.previous_employer_id,
pem.object_version_number,
paf.business_group_id as bg_id
from per_previous_employers pem, per_all_people_f paf
where pem.party_id=paf.party_id
and paf.person_id = p_person_id
and pem.person_id is null
and p_effective_date between paf.effective_start_date and paf.effective_end_date;
select qua.qualification_id,
qua.object_version_number,
paf.business_group_id as bg_id
from per_qualifications qua, per_all_people_f paf
where qua.party_id=paf.party_id
and paf.person_id = p_person_id
and qua.person_id is null
and p_effective_date between paf.effective_start_date and paf.effective_end_date;
select pea.attendance_id,
pea.object_version_number,
paf.business_group_id as bg_id
from per_establishment_attendances pea, per_all_people_f paf
where pea.party_id=paf.party_id
and paf.person_id = p_person_id
and pea.person_id is null
and p_effective_date between paf.effective_start_date and paf.effective_end_date;
select adr.address_id,
adr.object_version_number,
paf.business_group_id as bg_id,
paf.person_id as paf_person_id
from per_addresses adr, per_all_people_f paf
where paf.party_id = adr.party_id
and paf.current_employee_flag = 'Y'
and adr.person_id is null
and p_effective_date between paf.effective_start_date and paf.effective_end_date
and not exists (select 1 from per_all_people_f per2
where paf.party_id=per2.party_id
and paf.person_id<>per2.person_id
and per2.current_employee_flag='Y'
and p_effective_date between per2.effective_start_date
and per2.effective_end_date
and paf.creation_date > per2.creation_date);
select phn.phone_id,
phn.object_version_number,
paf.person_id as paf_person_id
from per_phones phn, per_all_people_f paf
where phn.party_id=paf.party_id
and paf.current_employee_flag = 'Y'
and phn.parent_id is null
and p_effective_date between paf.effective_start_date and paf.effective_end_date
and not exists (select 1 from per_all_people_f per2
where paf.party_id=per2.party_id
and paf.person_id<>per2.person_id
and per2.current_employee_flag='Y'
and p_effective_date between per2.effective_start_date
and per2.effective_end_date
and paf.creation_date > per2.creation_date);
select pem.previous_employer_id,
pem.object_version_number,
paf.business_group_id as bg_id,
paf.person_id as paf_person_id
from per_previous_employers pem, per_all_people_f paf
where pem.party_id=paf.party_id
and paf.current_employee_flag = 'Y'
and pem.person_id is null
and p_effective_date between paf.effective_start_date and paf.effective_end_date
and not exists (select 1 from per_all_people_f per2
where paf.party_id=per2.party_id
and paf.person_id<>per2.person_id
and per2.current_employee_flag='Y'
and p_effective_date between per2.effective_start_date
and per2.effective_end_date
and paf.creation_date > per2.creation_date);
select qua.qualification_id,
qua.object_version_number,
paf.business_group_id as bg_id,
paf.person_id as paf_person_id
from per_qualifications qua, per_all_people_f paf
where qua.party_id=paf.party_id
and paf.current_employee_flag = 'Y'
and qua.person_id is null
and qua.attendance_id is null
and p_effective_date between paf.effective_start_date and paf.effective_end_date
and not exists (select 1 from per_all_people_f per2
where paf.party_id=per2.party_id
and paf.person_id<>per2.person_id
and per2.current_employee_flag='Y'
and p_effective_date between per2.effective_start_date
and per2.effective_end_date
and paf.creation_date > per2.creation_date);
select pea.attendance_id,
pea.object_version_number,
paf.business_group_id as bg_id,
paf.person_id as paf_person_id
from per_establishment_attendances pea, per_all_people_f paf
where pea.party_id=paf.party_id
and paf.current_employee_flag = 'Y'
and pea.person_id is null
and p_effective_date between paf.effective_start_date and paf.effective_end_date
and not exists (select 1 from per_all_people_f per2
where paf.party_id=per2.party_id
and paf.person_id<>per2.person_id
and per2.current_employee_flag='Y'
and p_effective_date between per2.effective_start_date
and per2.effective_end_date
and paf.creation_date > per2.creation_date);