PAY Tax Audit Report Template

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: Tax Audit Report Template
Short Name: PYZATXAUR
DB package: PAY_ZA_TX_AUDIT_ARCHIVE
             SELECT :P_LE_NAME legal_entity 
                  , pai.action_information2 payroll_name
                  , pai.action_information3 bal_cat
                  , decode (pai.action_information3, 'Income'
                          , 1, 'Allowances'
                          , 2, 'Fringe Benefit'
                          , 3, 'Lump Sum'
                          , 4, 'Deductions'
                          , 5, 'Employer Contributions'
                          , 6, 'Gross Amounts' 
                          , 7) bal_cat_no
                  , pai.action_information4 rep_name
                  , pai.action_information5 code
                  , sum(nvl(pai.action_information6,0)) le_payroll_ytd_val
                  , sum(nvl(pai.action_information7,0)) le_payroll_rollup_val
               FROM pay_assignment_actions paa
                  , pay_action_information pai
              WHERE paa.payroll_action_id = :p_payroll_action_id
                AND paa.assignment_action_id = pai.action_context_id
                AND pai.action_context_type = 'AAP'
                AND pai.action_information_category = 'ZA_PAYROLL_VAL'
           group by pai.action_information2,pai.action_information3,pai.action_information4,pai.action_information5
            ORDER BY payroll_name
                   , to_number(bal_cat_no)
                   , code
Parameter NameSQL textValidation
Payroll Action ID
 
Char
Legal Entity Name
 
Char
Start Date
 
Date
End Date
 
Date
Payroll Name
 
LOV Oracle
Assignment Set
 
LOV Oracle
Detail Report
 
LOV Oracle
Download
Related Blitz Reports
PAY Payroll Reconciliation Detail PAY P46 EDI Process v6 Output PQP Generate MCR CSV PAY P46EXP EDI Process v6 Output PAY GB Pensions Automatic Enrollment not applied PAY Payroll Tax Report by Legal Employer PAY GB BIK Audit PAY RTI - Earlier Year Update Output 2014/15 PQP Teachers Pension MCR Reconciliation Report (Excel) PAY RTI ? Employer Alignment Submission Output
Blitz Report™