ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4716251A9E05362FB09050512Y 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 PAY PYGBRTNIC_XML US PAY Real Time Class 1A NIC Imported from BI Publisher Application: Payroll Source: Real Time Class 1A NIC Report Short Name: PYGBRTNIC_XML DB package: BI Publisher :p_payroll_action_id 1 10 :p_payroll_action_id LOV Oracle PAY_GB_RT_CLASS_1ANIC Y select ppa.payroll_action_id id, substr(to_char(ppa.effective_date,'DD-MON-YYYY') || ' (' || to_char(ppa.payroll_action_id) || ')',1,35) value, null description from pay_payroll_actions ppa where ppa.report_type in ('GB_RTNIC_ARCH') and ppa.report_qualifier='GB' and ppa.action_status='C' and ppa.action_type='X' and ppa.business_group_id=fnd_global.per_business_group_id order by ppa.effective_date desc Y US Archive Request ID Archive Request ID