The following lines contain the word 'select', 'insert', 'update' or 'delete':
select parameter_value
from pay_action_parameters
where parameter_name = 'US_ADVANCED_WAGE_ATTACHMENT';
select status
from pay_upgrade_definitions pud,
pay_upgrade_status pus
where pud.short_name = 'US_INV_DEDN_UPGRADE'
and pus.upgrade_definition_id = pud.upgrade_definition_id
and pus.business_group_id = cp_business_group_id;
PROCEDURE delete_deduction_element
(p_business_group_id in number
,p_element_type_id in number
,p_element_name in varchar2
,p_classification_name in varchar2
,p_category in varchar2
,p_processing_priority in number
,p_amount_rule in varchar2
,p_series_ee_bond in varchar2
,p_arrearage in varchar2
,p_stop_rule in varchar2
,p_calculation_ele_id in number
,p_vol_dedns_baltype_id in number
,p_primary_baltype_id in number
,p_accrued_baltype_id in number
,p_arrears_baltype_id in number
,p_not_taken_baltype_id in number
,p_tobondpurch_baltype_id in number
,p_able_baltype_id in number
,p_additional_baltype_id in number
,p_replacement_baltype_id in number
,p_special_inputs_ele_id in number
,p_special_features_ele_id in number
,p_verifier_ele_id in number
,p_eff_start_date in date
,p_eff_end_date in date
) IS
--
l_proc varchar2(80);
select template_id
from pay_element_templates
where base_name = p_element_name
and business_group_id = p_business_group_id
and template_type = 'U';
select element_type_extra_info_id
,object_version_number
from pay_element_type_extra_info
where element_type_id = p_element_type_id
and information_type = 'PQP_US_PRE_TAX_DEDUCTIONS'
and eei_information_category = 'PQP_US_PRE_TAX_DEDUCTIONS';
l_proc := g_proc||'.delete_deduction_element';
hr_us_garn_gen.delete_dedn
(p_business_group_id => p_business_group_id
,p_ele_type_id => p_element_type_id
,p_ele_name => p_element_name
,p_ele_priority => p_processing_priority
,p_ele_info_10 => p_primary_baltype_id
,p_ele_info_11 => p_accrued_baltype_id
,p_ele_info_12 => p_arrears_baltype_id
,p_ele_info_13 => p_not_taken_baltype_id
,p_ele_info_14 => p_tobondpurch_baltype_id
,p_ele_info_15 => p_able_baltype_id
,p_ele_info_16 => p_additional_baltype_id
,p_ele_info_17 => p_replacement_baltype_id
,p_ele_info_18 => p_special_inputs_ele_id
,p_ele_info_19 => p_special_features_ele_id
,p_ele_info_20 => p_verifier_ele_id
,p_ele_info_5 => p_calculation_ele_id
,p_ele_info_8 => p_vol_dedns_baltype_id
,p_del_sess_date => p_eff_start_date
,p_del_val_start_date => p_eff_start_date
,p_del_val_end_date => p_eff_end_date
);
pay_us_user_init_dedn.delete_user_init_template
(p_business_group_id => p_business_group_id
,p_ele_type_id => p_element_type_id
,p_ele_name => p_element_name
,p_effective_date => p_eff_start_date
);
pay_element_extra_info_api.delete_element_extra_info
(p_validate => false
,p_element_type_extra_info_id => c2_rec.element_type_extra_info_id
,p_object_version_number => c2_rec.object_version_number
);
end delete_deduction_element;