ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4717D51A9E05362FB09050512Y select tax.element_entry_id element_entry_id ,tax.effective_start_date effective_start_date ,per.full_name ,per.employee_number ,org.name ,asg.assignment_number ,asg.assignment_id, PER_PERDETBU_XMLP_PKG.cf_old_tax_classformula(asg.assignment_id, tax.element_entry_id) CF_OLD_TAX_CLASS, PER_PERDETBU_XMLP_PKG.cf_old_nocformula(asg.assignment_id, tax.element_entry_id) CF_old_noc, PER_PERDETBU_XMLP_PKG.cf_old_ytfiformula(asg.assignment_id, tax.element_entry_id) CF_old_ytfi, PER_PERDETBU_XMLP_PKG.cf_old_aytiformula(asg.assignment_id, tax.element_entry_id) CF_old_ayti, PER_PERDETBU_XMLP_PKG.cf_old_amtiformula(asg.assignment_id, tax.element_entry_id) CF_old_amti, PER_PERDETBU_XMLP_PKG.cf_old_mtfiformula(asg.assignment_id, tax.element_entry_id) CF_old_mtfi, PER_PERDETBU_XMLP_PKG.cf_new_tax_classformula(asg.assignment_id, tax.element_entry_id) CF_NEW_TAX_CLASS, PER_PERDETBU_XMLP_PKG.cf_new_nocformula(asg.assignment_id, tax.element_entry_id) CF_new_noc, PER_PERDETBU_XMLP_PKG.cf_new_ytfiformula(asg.assignment_id, tax.element_entry_id) CF_new_ytfi, PER_PERDETBU_XMLP_PKG.cf_new_aytiformula(asg.assignment_id, tax.element_entry_id) CF_new_ayti, PER_PERDETBU_XMLP_PKG.cf_new_amtiformula(asg.assignment_id, tax.element_entry_id) CF_new_amti, PER_PERDETBU_XMLP_PKG.cf_new_mtfiformula(asg.assignment_id, tax.element_entry_id) CF_new_mtfi from per_all_assignments_f asg ,per_all_people_f per ,hr_all_organization_units org ,hr_de_tax_information_v tax where :p_action ='UR' and tax.process_id = to_char(:p_conc_request_id) and tax.effective_start_date = :p_date_from and asg.assignment_id = tax.assignment_id and per.person_id = asg.person_id and org.organization_id = asg.organization_id and tax.effective_start_date BETWEEN asg.effective_start_date AND asg.effective_end_date and tax.effective_start_date between per.effective_start_date AND per.effective_end_date union all select to_number(null) element_entry_id, to_date(NULL) effective_start_date, per.full_name, per.employee_number, org.name, asg.assignment_number, asg.assignment_id, PER_PERDETBU_XMLP_PKG.cf_old_tax_classformula(asg.assignment_id, to_number(null)) CF_OLD_TAX_CLASS, PER_PERDETBU_XMLP_PKG.cf_old_nocformula(asg.assignment_id, to_number(null)) CF_old_noc, PER_PERDETBU_XMLP_PKG.cf_old_ytfiformula(asg.assignment_id, to_number(null)) CF_old_ytfi, PER_PERDETBU_XMLP_PKG.cf_old_aytiformula(asg.assignment_id, to_number(null)) CF_old_ayti, PER_PERDETBU_XMLP_PKG.cf_old_amtiformula(asg.assignment_id, to_number(null)) CF_old_amti, PER_PERDETBU_XMLP_PKG.cf_old_mtfiformula(asg.assignment_id, to_number(null)) CF_old_mtfi, PER_PERDETBU_XMLP_PKG.cf_new_tax_classformula(asg.assignment_id, to_number(null)) CF_NEW_TAX_CLASS, PER_PERDETBU_XMLP_PKG.cf_new_nocformula(asg.assignment_id, to_number(null)) CF_new_noc, PER_PERDETBU_XMLP_PKG.cf_new_ytfiformula(asg.assignment_id, to_number(null)) CF_new_ytfi, PER_PERDETBU_XMLP_PKG.cf_new_aytiformula(asg.assignment_id, to_number(null)) CF_new_ayti, PER_PERDETBU_XMLP_PKG.cf_new_amtiformula(asg.assignment_id, to_number(null)) CF_new_amti, PER_PERDETBU_XMLP_PKG.cf_new_mtfiformula(asg.assignment_id, to_number(null)) CF_new_mtfi FROM per_all_assignments_f asg, per_all_people_f per, hr_all_organization_units org, hr_de_asg_tax_batch_upd_v abu WHERE :p_action ='R' and abu.process_id = :p_conc_request_id and asg.assignment_id = abu.assignment_id and per.person_id = asg.person_id and org.organization_id = asg.organization_id and :p_date_from BETWEEN asg.effective_start_date and asg.effective_end_date and :p_date_from BETWEEN per.effective_start_date and per.effective_end_date PER PERDETBU_XML D PER Stapelaktualisierung Steuer Imported from BI Publisher Description: Auswertung "Stapelaktualisierung Steuer" für deutsche Lokalisierung Application: Human Resources Source: Stapelaktualisierung Steuer (XML) Short Name: PERDETBU_XML DB package: PER_PERDETBU_XMLP_PKG US PER Tax Batch Update Imported from BI Publisher Description: Tax Batch Update Report for German Localisation Application: Human Resources Source: Tax Batch Update (XML) Short Name: PERDETBU_XML DB package: PER_PERDETBU_XMLP_PKG BI Publisher :cp_top_org_name :p_action :p_add_tax_inc_meaning :p_add_tax_income :p_ass_set_meaning :p_assignment_set :p_business_group_id :p_conc_request_id :p_date_from :p_date_from_t :p_nu_child_meaning :p_nu_children :p_org_hier_meaning :p_org_hierarchy :p_rep_act_meaning :p_session_date :p_session_date_t :p_tax_class :p_tax_class_meaning :p_tax_free_inc_meaning :p_taxfree_income :p_top_org :p_top_org_meaning 1 -110 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y D Unternehmensgruppe Unternehmensgruppe US Business Group Business Group 2 -100 :p_org_hier_meaning Char select :$flex$.organisation_hierarchy.VALUE FROM DUAL D Bedeutung Organisationshierarchie Bedeutung Organisationshierarchie US Org Hierarchy Meaning Org Hierarchy Meaning 3 -90 :p_top_org_meaning Char select :$flex$.top_organisation.VALUE FROM DUAL D Bedeutung Übergeordnete Organisation Bedeutung Übergeordnete Organisation US Top Org meaning Top Org meaning 4 -80 :p_ass_set_meaning Char select :$flex$.assignment_set.VALUE FROM DUAL D Bedeutung StellenSet Bedeutung StellenSet US Assignment Set meaning Assignment Set meaning 5 -70 :p_rep_act_meaning Char select :$flex$.report_action.VALUE FROM DUAL Y D Bedeutung Auswertungsvorgang Bedeutung Auswertungsvorgang US Report Action Meaning Report Action Meaning 6 -60 :p_tax_class_meaning Char select :$flex$.tax_class.VALUE FROM DUAL Y D Bedeutung Steuerklasse Bedeutung Steuerklasse US Tax Class Meaning Tax Class Meaning 7 -50 :p_nu_child_meaning Char select :$flex$.number_of_children.VALUE FROM DUAL Y D Bedeutung Anzahl Kinder Bedeutung Anzahl Kinder US Number of Children Meaning Number of Children Meaning 8 -40 :p_tax_free_inc_meaning Char select :$flex$.tax_free_income.VALUE FROM DUAL Y D Bedeutung Steuerfreibetrag Bedeutung Steuerfreibetrag US Tax Free Income Meaning Tax Free Income Meaning 9 -30 :p_add_tax_inc_meaning Char select :$flex$.additional_taxable_income.VALUE FROM DUAL Y D Bedeutung Hinzurechnungsbetrag Bedeutung Hinzurechnungsbetrag US Add Tax Income Meaning Add Tax Income Meaning 10 -20 :p_session_date Date select fnd_date.date_to_displaydate(effective_date) from fnd_sessions where session_id = userenv('sessionid') Y D Gültigkeitsdatum Gültigkeitsdatum US Effective Date Effective Date 11 10 :p_date_from Date sysdate Y D Von Datum Von Datum US From Date From Date 12 20 :p_org_hierarchy LOV Oracle HR_DE_ORG_STRUCT Y select s.organization_structure_id id, s.name value, null description from per_organization_structures s where s.business_group_id=fnd_global.per_business_group_id order by value,description D Organisationshierarchie Organisationshierarchie US Organisation Hierarchy Organisation Hierarchy 13 30 :p_top_org LOV Oracle HR_DE_ORGANIZATIONS Y select organization_id id, name value, null description from hr_organization_units hou where hou.organization_id in ( select pose.organization_id_parent from per_org_structure_elements pose ,per_org_structure_versions posv where pose.org_structure_version_id=posv.org_structure_version_id and posv.organization_structure_id= :$flex$.hr_de_org_struct union select pose.organization_id_child from per_org_structure_elements pose ,per_org_structure_versions posv where pose.org_structure_version_id=posv.org_structure_version_id and posv.organization_structure_id= :$flex$.hr_de_org_struct) order by value,description D Übergeordnete Organisation Übergeordnete Organisation US Top Organisation Top Organisation 14 40 :p_assignment_set LOV Oracle HR_DE_BU_ASSIGNMENT_SET Y select has.assignment_set_id id, has.assignment_set_name value, null description from hr_assignment_sets has where has.business_group_id=fnd_global.per_business_group_id and has.assignment_set_id in (select hasa.assignment_set_id from hr_assignment_set_amendments hasa where hasa.include_or_exclude='I') order by value,description D StellenSet StellenSet US Assignment Set Assignment Set 15 50 :p_action LOV Oracle HR_DE_BU_ACTION Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='DE_TAX_UPD_ACTIONS' order by value,description select meaning from hr_lookups where lookup_type = 'DE_TAX_UPD_ACTIONS' and lookup_code = 'R' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) Y D Auswertungsvorgang Auswertungsvorgang US Report Action Report Action 16 60 :p_tax_class LOV Oracle HR_DE_BU_NO_CHANGE_OR_SIX Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='DE_TAX_UPD_OPT' and lookup_code in ('NC','SIX') order by value,description select meaning from hr_lookups where lookup_type = 'DE_TAX_UPD_OPT' and lookup_code = 'NC' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) Y D Steuerklasse Steuerklasse US Tax Class Tax Class 17 70 :p_nu_children LOV Oracle HR_DE_BU_NO_CHANGE_OR_ZERO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='DE_TAX_UPD_OPT' and lookup_code in ('NC','ZERO') order by value,description select meaning from hr_lookups where lookup_type = 'DE_TAX_UPD_OPT' and lookup_code = 'NC' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) Y D Anzahl Kinder Anzahl Kinder US Number of Children Number of Children 18 80 :p_taxfree_income LOV Oracle HR_DE_BU_NO_CHANGE_OR_ZERO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='DE_TAX_UPD_OPT' and lookup_code in ('NC','ZERO') order by value,description select meaning from hr_lookups where lookup_type = 'DE_TAX_UPD_OPT' and lookup_code = 'NC' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) Y D Steuerfreibetrag Steuerfreibetrag US Tax Free Income Tax Free Income 19 90 :p_add_tax_income LOV Oracle HR_DE_BU_NO_CHANGE_OR_ZERO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='DE_TAX_UPD_OPT' and lookup_code in ('NC','ZERO') order by value,description select meaning from hr_lookups where lookup_type = 'DE_TAX_UPD_OPT' and lookup_code = 'NC' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) Y D Hinzurechnungsbetrag Hinzurechnungsbetrag US Additional Taxable Income Additional Taxable Income