The following lines contain the word 'select', 'insert', 'update' or 'delete':
pay_in_termination_pkg.delete_termination_elements
(p_period_of_service_id => p_period_of_service_id
,p_business_group_id => p_business_group_id
,p_actual_termination_date => p_actual_termination_date
,p_calling_procedure => p_calling_procedure
,p_message_name => p_message_name
,p_token_name => p_token_name
,p_token_value => p_token_value);
SELECT final_process_date
,actual_termination_date
FROM per_periods_of_service
WHERE period_of_service_id = p_period_of_service_id;
SELECT pos.business_group_id
,pos.actual_termination_date
FROM per_periods_of_service pos
WHERE pos.period_of_service_id = p_period_of_service_id;
PROCEDURE update_pds_details
(p_period_of_service_id IN NUMBER
,p_effective_date IN DATE
,p_leaving_reason IN VARCHAR2
)
IS
CURSOR c_pos_dtls IS
SELECT pos.actual_termination_date
,ppf.business_group_id
FROM per_periods_of_service pos
,per_assignments_f paf
,per_people_f ppf
WHERE pos.period_of_service_id = p_period_of_service_id
AND pos.period_of_service_id = paf.period_of_service_id
AND paf.person_id = ppf.person_id
AND p_effective_date BETWEEN ppf.effective_start_date
AND ppf.effective_end_date
AND p_effective_date BETWEEN paf.effective_start_date
AND paf.effective_end_date;
l_procedure := g_package || 'update_pds_details' ;
pay_in_termination_pkg.delete_gratuity_entry
(p_period_of_service_id => p_period_of_service_id
,p_business_group_id => l_business_group_id
,p_actual_termination_date => l_actual_termination_date
,p_calling_procedure => l_procedure
,p_message_name => g_message_name
,p_token_name => g_token_name
,p_token_value => g_token_value
);
END update_pds_details;