ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3333869E053B46B63588994 SELECT ppa.request_id REQUEST_ID, SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'TAX_REF'),1,20) PAYE_REFERENCE, TO_CHAR(FND_DATE.CANONICAL_TO_DATE(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'EFFECTIVE_DATE')),'DD-MON-YYYY') EFFECTIVE_DATE, DECODE(SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'EMP_INC'),1,20),'ZPL','Zero PAYE Liability','Non Zero PAYE Liability') PAYE_LIABILITY, DECODE(SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'SORT_ORDER'),1,20),'FULL_NAME', 'Employee Name','NI_NUMBER','NI Number') REP_SORT_ORDER, pai.ACTION_INFORMATION1 COMPANY_NAME, pai.ACTION_INFORMATION2 EMPLOYER_NAME, pai.ACTION_INFORMATION3 ACCOUNT_OFFICE_REFERENCE, pai.ACTION_INFORMATION4 HMRC_OFFICE_NUMBER, pai.ACTION_INFORMATION5 SAUTR, pai.ACTION_INFORMATION6 COTAXREF, pai.ACTION_INFORMATION7 PERSON_COUNT FROM pay_action_information pai, pay_payroll_actions ppa WHERE ppa.payroll_action_id = :PAYROLL_ACTION_ID and pai.ACTION_CONTEXT_ID = :PAYROLL_ACTION_ID and pai.ACTION_CONTEXT_TYPE = 'PA' and pai.ACTION_INFORMATION_CATEGORY = 'GB RTI REC PAYROLL INFO' Y PAY PYGBPENNREPOP US PAY Penny Deduction Detail Report Output Application: Payroll Source: Penny Deduction Detail Report Output Short Name: PYGBPENNREPOP DB package: BI Publisher :payroll_action_id 1 10 :payroll_action_id Char Y US Payroll Action ID 2 20 :sort_order Char Y US Sort Order