PAY Real Time Class 1A NIC
Description
- Categories
- BI Publisher
- Application
- Payroll
- Source
- Real Time Class 1A NIC Report
- Short Name
- PYGBRTNIC_XML
Imported from BI Publisher
DB package:
DB package:
SQL 12 lines
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 |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Archive Request ID | LOV Oracle |