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

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 :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 Name SQL text Validation
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™

Blitz Report™ provides multiple benefits: