ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4717651A9E05362FB09050512Y select sum(fnd_number.canonical_to_number(pai.action_information2)) TOTAL_DEDUCTION, max(TOTAL_DEDUCTION_DESC) TOTAL_DEDUCTION_DESC, sum(fnd_number.canonical_to_number(pai.action_information3)) SITE, max(SITE_DESC) SITE_DESC, sum(fnd_number.canonical_to_number(pai.action_information4)) PAYE, max(PAYE_DESC) PAYE_DESC, sum(fnd_number.canonical_to_number(pai.action_information5)) PAYE_RET_LUM_BEN, max(PAYE_RET_LUM_BEN_DESC) PAYE_RET_LUM_BEN_DESC, sum(fnd_number.canonical_to_number(pai.action_information6)) UIF_CONTRIBUTION, max(UIF_CONTRIBUTION_DESC) UIF_CONTRIBUTION_DESC, sum(fnd_number.canonical_to_number(pai.action_information7)) SDL_CONTRIBUTION, max(SDL_CONTRIBUTION_DESC) SDL_CONTRIBUTION_DESC, sum(fnd_number.canonical_to_number(pai.action_information8)) TOT_TAX_UIF_SDL, max(TOT_TAX_UIF_SDL_DESC) TOT_TAX_UIF_SDL_DESC, sum(fnd_number.canonical_to_number(pai.action_information13)) MED_TAX_CR, max(MED_TAX_CR_DESC) MED_TAX_CR_DESC, sum(fnd_number.canonical_to_number(pai.action_information23)) ADD_MED_TAX_CR, max(ADD_MED_TAX_CR_DESC) ADD_MED_TAX_CR_DESC from pay_action_information pai, pay_assignment_actions paa, (select max(decode(sars.lookup_code,4497,sars.meaning)) TOTAL_DEDUCTION_DESC, max(decode(sars.lookup_code,4101,sars.meaning)) SITE_DESC, max(decode(sars.lookup_code,4102,sars.meaning)) PAYE_DESC, max(decode(sars.lookup_code,4115,sars.meaning)) PAYE_RET_LUM_BEN_DESC, max(decode(sars.lookup_code,4141,sars.meaning)) UIF_CONTRIBUTION_DESC, max(decode(sars.lookup_code,4142,sars.meaning)) SDL_CONTRIBUTION_DESC, max(decode(sars.lookup_code,4149,sars.meaning)) TOT_TAX_UIF_SDL_DESC, max(decode(sars.lookup_code,4116,sars.meaning)) MED_TAX_CR_DESC, max(decode(sars.lookup_code,4120,sars.meaning)) ADD_MED_TAX_CR_DESC from hr_lookups sars where sars.lookup_type(+) = 'ZA_SARS_CODE_DESCRIPTIONS' and sars.application_id(+) = 800 and sars.lookup_code in (4497,4101,4102,4115,4141,4142,4149,4116,4120)) des where pai.action_context_id = paa.assignment_action_id and pai.action_context_type = 'AAP' and pai.action_information_category = 'ZATYE_EMPLOYEE_TAX_AND_REASONS' and pai.action_information30 is not null &C_PAYROLL_ACTION_ID PAY PYZASOTC_XML US PAY Summary of Tax Certificates Imported from BI Publisher Application: Payroll Source: Summary of Tax Certificates Short Name: PYZASOTC_XML DB package: PAY_ZA_SOTC_PKG BI Publisher &c_payroll_action_id :c_payroll_action_id :cp_bg_name :cp_cert_count :cp_first_cert_num :cp_last_cert_num :cp_le_name :cp_man_cert_count :cp_payroll_action_id :cp_period_recon :cp_tax_ref :cp_tax_year :p_business_group_id :p_legal_entity_id :p_payroll_action_id :p_period_recon :p_tax_year 1 -30 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group ID Business Group ID 2 -20 :p_certificate_type LOV Oracle ZA_TAX_CERTIFICATES Y select hl.lookup_code id, hl.meaning value, hl.description description from hr_lookups hl where hl.lookup_type='ZA_TAX_CERTIFICATES' and hl.application_id=800 and hl.enabled_flag='Y' order by value,description select meaning from HR_LOOKUPS where lookup_type='ZA_TAX_CERTIFICATES' and lookup_code='1' Y US ZA_TAX_CERTIFICATES Certificate Type 3 10 :p_tax_year Number Y US PAY_ZA_TAX_YEAR Tax Year 4 20 :p_period_recon LOV Oracle PAY_ZA_PERIOD_OF_RECON Y select hl.lookup_code id, hl.meaning value, null description from hr_lookups hl where lookup_type='PAY_ZA_PERIOD_OF_RECON' and enabled_flag='Y' order by value,description Y US Period of Reconciliation Period of Reconciliation 5 30 :p_legal_entity_id LOV Oracle PAY_ZA_TAX_LEGAL_ENTITY Y select haou.organization_id id, haou.name value, null description from fnd_sessions fss,hr_all_organization_units haou,hr_organization_information hoi,hr_organization_information hoi2 where fss.session_id=userenv('sessionid') and fss.effective_date between haou.date_from and nvl(haou.date_to,to_date('31-12-4712','DD-MM-YYYY')) and haou.business_group_id=fnd_global.per_business_group_id and hoi.organization_id=haou.organization_id and hoi.org_information_context='ZA_LEGAL_ENTITY' and hoi2.organization_id=haou.organization_id and hoi2.org_information_context='CLASS' and hoi2.org_information1='HR_LEGAL' and hoi2.org_information2='Y' and exists (select 1 from pay_payroll_actions ppa where ppa.business_group_id+0=fnd_global.per_business_group_id and ppa.action_type='X' and ppa.report_type='ZA_TYE' and ppa.action_status='C' and pay_za_irp5_archive_pkg.get_parameter('TAX_YEAR',ppa.legislative_parameters)=:$flex$.pay_za_tax_year and pay_za_irp5_archive_pkg.get_parameter('CERT_TYPE',ppa.legislative_parameters)=:$flex$.za_tax_certificates and pay_za_irp5_archive_pkg.get_parameter('LEGAL_ENTITY',ppa.legislative_parameters)=haou.organization_id ) order by haou.name Y US Legal Entity Legal Entity ID 6 40 :p_payroll_action_id LOV Oracle PAY_ZA_TAX_PREPROCESS Y select ppa.payroll_action_id id, to_char(ppa.effective_date,'DD-MON-YYYY') || '(' || to_char(ppa.payroll_action_id)||')' value, null description from pay_payroll_actions ppa where ppa.business_group_id+0=fnd_global.per_business_group_id and ppa.action_type='X' and ppa.report_type='ZA_TYE' and ppa.action_status='C' and pay_za_irp5_archive_pkg.get_parameter('TAX_YEAR',ppa.legislative_parameters)=:$flex$.pay_za_tax_year and nvl(pay_za_irp5_archive_pkg.get_parameter('PERIOD_RECON',ppa.legislative_parameters),'02')=:$flex$.pay_za_period_of_recon and pay_za_irp5_archive_pkg.get_parameter('CERT_TYPE',ppa.legislative_parameters)=:$flex$.za_tax_certificates and pay_za_irp5_archive_pkg.get_parameter('LEGAL_ENTITY',ppa.legislative_parameters)=:$flex$.pay_za_tax_legal_entity order by ppa.request_id desc US Tax Certificate Preprocess Tax Certificate Preprocess