[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
,p_resume_last_updated DATE
,p_office_number VARCHAR2
,p_internal_location VARCHAR2
,p_mailstop VARCHAR2
,p_honors VARCHAR2
,p_pre_name_adjunct VARCHAR2
,p_hold_applicant_date_until DATE
,p_benefit_group_id NUMBER
,p_receipt_of_death_cert_date DATE
,p_coord_ben_med_pln_no VARCHAR2
,p_coord_ben_no_cvg_flag VARCHAR2
,p_uses_tobacco_flag VARCHAR2
,p_dpdnt_adoption_date DATE
,p_dpdnt_vlntry_svce_flag VARCHAR2
,p_date_of_death DATE
,p_original_date_of_hire DATE
,p_period_of_service_id NUMBER
,p_town_of_birth VARCHAR2
,p_region_of_birth VARCHAR2
,p_country_of_birth VARCHAR2
,p_global_person_id VARCHAR2
,p_npw_number VARCHAR2
,p_current_npw_flag VARCHAR2
) is
--
-- Define cursor.
--
cursor per is select *
from per_people_v
where row_id = chartorowid(p_rowid);
cursor per1 is select *
from per_people_f
where rowid = chartorowid(p_rowid)
for update nowait;
per_rec.resume_last_updated := trunc(per_rec.resume_last_updated);
and ((per_rec.resume_last_updated = p_resume_last_updated)
or (per_rec.resume_last_updated is null
and (p_resume_last_updated is null)))
and ((per_rec.office_number = p_office_number)
or (per_rec.office_number is null
and (p_office_number is null)))
and ((per_rec.internal_location = p_internal_location)
or (per_rec.internal_location is null
and (p_internal_location is null)))
and ((per_rec.mailstop = p_mailstop)
or (per_rec.mailstop is null
and (p_mailstop is null)))
and ((per_rec.honors = p_honors)
or (per_rec.honors is null
and (p_honors is null)))
and ((per_rec.pre_name_adjunct = p_pre_name_adjunct)
or (per_rec.pre_name_adjunct is null
and (p_pre_name_adjunct is null)))
and ((per_rec.hold_applicant_date_until = p_hold_applicant_date_until)
or (per_rec.hold_applicant_date_until is null
and (p_hold_applicant_date_until is null)))
and ((per_rec.benefit_group_id = p_benefit_group_id)
or (per_rec.benefit_group_id is null
and (p_benefit_group_id is null)))
and ((per_rec.receipt_of_death_cert_date = p_receipt_of_death_cert_date)
or (per_rec.receipt_of_death_cert_date is null
and (p_receipt_of_death_cert_date is null)))
and ((per_rec.coord_ben_med_pln_no = p_coord_ben_med_pln_no)
or (per_rec.coord_ben_med_pln_no is null
and (p_coord_ben_med_pln_no is null)))
and ((per_rec.coord_ben_no_cvg_flag = p_coord_ben_no_cvg_flag )
or ( per_rec.coord_ben_no_cvg_flag is null
and (p_coord_ben_no_cvg_flag is null)))
and ((per_rec.uses_tobacco_flag = p_uses_tobacco_flag)
or (per_rec.uses_tobacco_flag is null
and (p_uses_tobacco_flag is null)))
and (( per_rec.dpdnt_adoption_date = p_dpdnt_adoption_date)
or (per_rec.dpdnt_adoption_date is null
and (p_dpdnt_adoption_date is null)))
and ((per_rec.dpdnt_vlntry_svce_flag = p_dpdnt_vlntry_svce_flag)
or (per_rec.dpdnt_vlntry_svce_flag is null
and (p_dpdnt_vlntry_svce_flag is null)))
and ((per_rec.date_of_death = p_date_of_death)
or (per_rec.date_of_death is null
and (p_date_of_death is null)))
and ((per_rec.original_date_of_hire = p_original_date_of_hire)
or (per_rec.original_date_of_hire is null
and (p_original_date_of_hire is null)))
and ((per_rec.period_of_service_id = p_period_of_service_id)
or (per_rec.period_of_service_id is null
and (p_period_of_service_id is null)))
and ((per_rec.npw_number = p_npw_number)
or (per_rec.npw_number is null
and (p_npw_number is null)))
and ((per_rec.current_npw_flag = p_current_npw_flag)
or (per_rec.current_npw_flag is null
and (p_current_npw_flag is null)))
) then
open per1;