[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
hr_startup_data_api_support.delete_owner_definitions;
select business_group_id
from per_business_groups
where name = p_business_group_name;
select event_group_id
from pay_event_groups evg
where evg.event_group_name = p_event_group_name
and nvl(evg.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
and nvl(evg.business_group_id,hr_api.g_number) = nvl(p_business_group_id,hr_api.g_number);
select element_set_id
from pay_element_sets els
where els.element_set_name = p_element_set_name
and nvl(els.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
and nvl(els.business_group_id,hr_api.g_number) = nvl(p_business_group_id,hr_api.g_number);
select user_entity_id
from ff_user_entities
where user_entity_name = p_user_entity_name
and nvl(legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
and business_group_id is null;
select distinct ff.formula_id
from ff_formulas_f ff
,ff_formula_types ft
where ff.formula_name = p_formula_name
and nvl(ff.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
and ft.formula_type_name = p_formula_type_name
and ft.formula_type_id = ff.formula_type_id
and ff.business_group_id is null;
select null
from pay_report_format_mappings_f
where report_type = p_report_type
and report_qualifier = p_report_qualifier
and report_category = p_report_category;
select min(rfi.effective_start_date), max(rfi.effective_end_date)
from pay_report_format_items_f rfi
where rfi.report_type = g_rfm_old_rec.report_type
and rfi.report_qualifier = g_rfm_old_rec.report_qualifier
and rfi.report_category = g_rfm_old_rec.report_category;
select rfi.report_format_item_id, rfi.object_version_number
from pay_report_format_items_f rfi
where rfi.report_type = g_rfm_old_rec.report_type
and rfi.report_qualifier = g_rfm_old_rec.report_qualifier
and rfi.report_category = g_rfm_old_rec.report_category
and p_effective_date between
rfi.effective_start_date and rfi.effective_end_date ;
,p_datetrack_mode => 'DELETE'
,p_report_format_item_id => l_rfi_id.report_format_item_id
,p_object_version_number => l_rfi_id.object_version_number
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date );
,p_datetrack_mode => 'DELETE'
,p_report_format_mapping_id => g_rfm_old_rec.report_format_mapping_id
,p_object_version_number => g_rfm_old_rec.object_version_number
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
);
delete from pay_report_format_mappings_f
where report_format_mapping_id = l_report_format_mapping_id;
delete from pay_report_format_mappings_tl rfmtl
where rfmtl.report_format_mapping_id = l_report_format_mapping_id
and exists
( select null
from fnd_languages l
where l.installed_flag in ('I','B')
and l.language_code = rfmtl.language );
,p_datetrack_mode => 'UPDATE'
,p_rec => l_rec );
select null
from pay_report_format_items_f
where report_type = p_report_type
and report_qualifier = p_report_qualifier
and report_category = p_report_category
and user_entity_id = l_user_entity_id;
,p_datetrack_mode => 'DELETE'
,p_report_format_item_id => g_rfi_old_rec.report_format_item_id
,p_object_version_number => g_rfi_old_rec.object_version_number
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
);
delete from pay_report_format_items_f
where report_format_item_id = l_report_format_item_id;
,p_datetrack_mode => 'UPDATE'
,p_rec => l_rec );
select object_version_number
from pay_report_format_parameters
where report_format_mapping_id = l_report_format_mapping_id
and parameter_name = p_parameter_name;
select null
from pay_magnetic_blocks
where magnetic_block_id = l_magnetic_block_id;
select null
from pay_magnetic_records
where magnetic_block_id = l_magnetic_block_id
and sequence = p_sequence;
select null
from pay_event_group_usages egu
where egu.event_group_id = l_event_group_id
and egu.element_set_id = l_element_set_id
and ( l_business_group_id is null
or ( l_business_group_id is not null and l_business_group_id = egu.business_group_id )
or ( l_business_group_id is not null and
egu.legislation_code is null and egu.business_group_id is null )
or ( l_business_group_id is not null and
egu.legislation_code = hr_api.return_legislation_code(l_business_group_id )))
and ( l_legislation_code is null
or ( l_legislation_code is not null and l_legislation_code = egu.legislation_code )
or ( l_legislation_code is not null and
egu.legislation_code is null and egu.business_group_id is null)
or ( l_legislation_code is not null and
l_legislation_code = hr_api.return_legislation_code(egu.business_group_id )));
select prt.run_type_id
from pay_run_types_f prt
where UPPER(prt.run_type_name) = UPPER(p_rt_name)
and p_effective_start_date between prt.effective_start_date
and prt.effective_end_date
and ((p_rt_business_group_name is not null
and prt.business_group_id = l_business_group_id)
or (p_rt_legislation_code is not null
and prt.legislation_code = p_rt_legislation_code)
or (p_rt_business_group_name is null
and p_rt_legislation_code is null
and prt.business_group_id is null
and prt.legislation_code is null));
select pec.classification_id
from pay_element_classifications pec
where UPPER(pec.classification_name) = UPPER(p_ec_classification_name)
and ((p_ec_business_group_name is not null
and pec.business_group_id = l_business_group_id)
or (p_ec_legislation_code is not null
and pec.legislation_code = p_ec_legislation_code)
or (p_ec_business_group_name is null
and p_ec_legislation_code is null
and pec.business_group_id is null
and pec.legislation_code is null));
select element_class_usage_id, object_version_number
from pay_element_class_usages_f
where run_type_id = l_run_type_id
and classification_id = l_classification_id
and NVL(business_group_id, hr_api.g_number) = NVL(l_business_group_id, hr_api.g_number)
and NVL(legislation_code, hr_api.g_varchar2) = NVL(p_legislation_code, hr_api.g_varchar2)
and p_effective_start_date between effective_start_date and effective_end_date;
,p_datetrack_mode => 'DELETE'
,p_element_class_usage_id => g_ecu_old_rec.element_class_usage_id
,p_object_version_number => g_ecu_old_rec.object_version_number
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date);
,p_datetrack_mode => 'UPDATE'
,p_rec => l_rec );