PAY Penny Deduction Detail Report Output

Description
Categories: BI Publisher, Human Resources
Application: Payroll
Source: Penny Deduction Detail Report Output
Short Name: PYGBPENNREPOP
DB package:
					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'
Parameter Name SQL text Validation
Sort Order
 
Payroll Action ID