[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select distinct(paaf.assignment_id)
from per_all_assignments_f paaf
,per_assignment_status_types past
,hr_soft_coding_keyflex kyflex
where paaf.period_of_service_id=p_period_of_service_id
and (p_actual_termination_date+1) between paaf.effective_start_date
and paaf.effective_end_date
and paaf.assignment_status_type_id=past.assignment_status_type_id
and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
and kyflex.soft_coding_keyflex_id=paaf.soft_coding_keyflex_id
and kyflex.segment3='NORMAL';
select paye_details_id
,object_version_number ovn
,effective_start_date
from pay_pl_paye_details_f
where per_or_asg_id=r_per_or_asg_id
and contract_category='TERM_NORMAL';
select sii_details_id
,object_version_number ovn
,effective_start_date
from pay_pl_sii_details_f
where per_or_asg_id=r_per_or_asg_id
and contract_category='TERM_NORMAL';
pay_pl_paye_api.delete_pl_paye_details
(p_validate =>false
,p_effective_date =>l_csr_term_paye_records.effective_start_date
,p_datetrack_delete_mode =>'ZAP'
,p_paye_details_id =>l_csr_term_paye_records.paye_details_id
,p_object_version_number =>l_csr_term_paye_records.ovn
,p_effective_start_date =>l_temp_effective_start_date
,p_effective_end_date =>l_temp_effective_start_date
);
pay_pl_sii_api.delete_pl_sii_details
(p_validate =>false
,p_effective_date =>l_csr_term_sii_records.effective_start_date
,p_datetrack_delete_mode =>'ZAP'
,p_sii_details_id =>l_csr_term_sii_records.sii_details_id
,p_object_version_number =>l_csr_term_sii_records.ovn
,p_effective_start_date =>l_temp_effective_start_date
,p_effective_end_date =>l_temp_effective_start_date
);