[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select min(paaf.effective_start_date),
paaf.assignment_id,
paaf.person_id
from per_all_assignments_f paaf,
per_assignment_status_types past,
hr_soft_coding_keyflex kflex
where period_of_service_id=p_period_of_service_id
and past.ASSIGNMENT_STATUS_TYPE_ID=paaf.ASSIGNMENT_STATUS_TYPE_ID
and PER_SYSTEM_STATUS='TERM_ASSIGN'
and kflex.soft_coding_keyflex_id=paaf.soft_coding_keyflex_id
and kflex.segment3='NORMAL'
group by paaf.assignment_id,paaf.person_id;
select effective_start_date,
paye_details_id,
tax_reduction,
tax_calc_with_spouse_child,
income_reduction,
income_reduction_amount,
rate_of_tax,
object_version_number
from pay_pl_paye_details_f
where contract_category=r_contract_category
and per_or_asg_id =r_per_or_asg_id
and ( r_effective_date is null or
r_effective_date between effective_start_date and effective_end_date
)
and rownum=1;
select effective_start_date,sii_details_id,
emp_social_security_info,object_version_number,
old_age_contribution,pension_contribution,
sickness_contribution,work_injury_contribution,
labor_contribution,health_contribution,
unemployment_contribution,old_age_cont_end_reason,
pension_cont_end_reason,sickness_cont_end_reason,
work_injury_cont_end_reason,labor_fund_cont_end_reason,
health_cont_end_reason,unemployment_cont_end_reason
from pay_pl_sii_details_f
where per_or_asg_id=r_per_or_asg_id
and contract_category=r_contract_category
and ( r_effective_date is null or
r_effective_date between effective_start_date and effective_end_date
)
and rownum=1;
pay_pl_paye_api.delete_pl_paye_details
( p_validate =>false
,p_effective_date =>l_csr_paye_details.effective_start_date
,p_datetrack_delete_mode =>'ZAP'
,p_paye_details_id =>l_csr_paye_details.paye_details_id
,p_object_version_number =>l_csr_paye_details.object_version_number
,p_effective_start_date =>l_temp_effective_start_date
,p_effective_end_date =>l_temp_effective_end_date
);
pay_pl_sii_api.delete_pl_sii_details
( p_validate =>false
,p_effective_date =>l_csr_sii_details.effective_start_date
,p_datetrack_delete_mode =>'ZAP'
,p_sii_details_id =>l_csr_sii_details.sii_details_id
,p_object_version_number =>l_csr_sii_details.object_version_number
,p_effective_start_date =>l_temp_effective_start_date
,p_effective_end_date =>l_temp_effective_end_date
);