PAY Real Time Class 1A NIC

Description
Categories: BI Publisher
Imported from BI Publisher
Application: Payroll
Source: Real Time Class 1A NIC Report
Short Name: PYGBRTNIC_XML
DB package:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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