The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT classification_id
FROM pay_element_classifications
WHERE classification_name = 'Information'
AND legislation_code = 'HU';
SELECT decode(p_ee_element,'Y',nvl(ee_contribution_percent,0),nvl(er_contribution_percent,0))
,decode(p_ee_element,'Y',nvl(ee_contribution_fixed_rate,0),nvl(er_contribution_fixed_rate,0))
FROM pqp_pension_types_f
WHERE pension_type_id = p_pension_type
AND p_effective_start_date BETWEEN effective_start_date
AND effective_end_date;
PROCEDURE delete_pension_objects_swi
(p_validate NUMBER DEFAULT hr_api.g_false_num
,p_element_type_id IN NUMBER
,p_effective_date IN DATE
,p_object_version_number IN NUMBER
,p_return_status OUT NOCOPY VARCHAR2 ) IS
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'delete_pension_objects_swi';
savepoint delete_pension_objects_swi;
per_hu_pension_objects.delete_pension_objects(
p_validate => l_validate
,p_element_type_id => p_element_type_id
,p_effective_date => p_effective_date
,p_object_version_number => p_object_version_number);
rollback to delete_pension_objects_swi;
rollback to delete_pension_objects_swi;
END delete_pension_objects_swi;
PROCEDURE delete_pension_objects(p_validate BOOLEAN DEFAULT FALSE
,p_element_type_id NUMBER
,p_effective_date DATE
,p_object_version_number NUMBER
) IS
--
l_element_type_id pay_element_types_f.element_type_id%TYPE;
SELECT business_group_id FROM pay_element_types_f
WHERE element_type_id=p_element_type_id
AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
SELECT input_value_id,object_version_number FROM pay_input_values_f
WHERE name = p_input_name
AND element_type_id = p_element_type_id--l_element_type_id
AND business_group_id = l_business_group_id
AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
SELECT element_type_extra_info_id,object_version_number
FROM pay_element_type_extra_info
WHERE eei_information_category = 'HU_PENSION_SCHEME_INFO'
AND element_type_id = p_element_type_id;--l_element_type_id;
pay_input_value_api.delete_input_value
( p_validate => p_validate
,p_effective_date => p_effective_date
,p_datetrack_delete_mode => 'ZAP'
,p_input_value_id => l_input_value_id
,p_object_version_number => l_inp_ovn -- in/out
,p_effective_start_date => l_effective_start_date -- out
,p_effective_end_date => l_effective_end_date -- out
,p_balance_feeds_warning => l_balance_feeds_warning -- out
);
pay_element_extra_info_api.delete_element_extra_info
(p_validate => p_validate
,p_element_type_extra_info_id => l_element_extra_info_id
,p_object_version_number => l_extra_info_ovn
) ;
pay_element_types_api.delete_element_type
(p_validate => p_validate
,p_effective_date => p_effective_date
,p_datetrack_delete_mode => 'ZAP'
,p_element_type_id => p_element_type_id
,p_object_version_number => l_object_version_number
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_start_date
,p_balance_feeds_warning => l_balance_feeds_warning
,p_processing_rules_warning => l_processing_rules_warning
) ;
END delete_pension_objects;