PAY Real Time Class 1A NIC

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Payroll
Source: Real Time Class 1A NIC Report
Short Name: PYGBRTNIC_XML
DB package:
Run PAY Real Time Class 1A NIC and other Oracle EBS reports with Blitz Report™ on our demo environment
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,'EFF_DT')),'DD-MON-YYYY') EFFECTIVE_DATE
					,to_number(fg.global_value)*100 CLS_1ANIC_PCT
				FROM    pay_payroll_actions ppa,
				FF_GLOBALS_F FG
				WHERE   ppa.payroll_action_id = :P_PAYROLL_ACTION_ID
				AND     fg.legislation_code = 'GB'
				AND     fg.global_name = 'NI_ERS_RATE'
				AND     fnd_date.canonical_to_date(pay_gb_eoy_archive.get_parameter (ppa.legislative_parameters,'EFF_DT'))
									BETWEEN fg.effective_start_date AND fg.effective_end_date
Parameter Name SQL text Validation
Archive Request ID 
 
 LOV Oracle
Download
Related Blitz Reports
PAY IR8S Summary PAY A8B Summary PAY P45 A4 PAY IR8A Summary PAY A8B Summary (1) PAY A8A Summary PAY P45 Report (laser) PAY Pay Advice PAY P45
Blitz Report™

Blitz Report™ provides multiple benefits: