PAY Dutch Labour Cost Agreement Audit

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Dutch Labour Cost Agreement - Audit Report
Application: Payroll
Source: Dutch Labour Cost Agreement Audit Report
Short Name: PAY_NL_LCA_AUDIT
DB package:
Run PAY Dutch Labour Cost Agreement Audit and other Oracle EBS reports with Blitz Report™ on our demo environment
         SELECT  generator.request_id request_id
               ,info.action_information29 sequence_number
               ,info.action_information1 method
               ,fnd_number.canonical_to_number(info.action_information26) threshold_rate
               ,fnd_number.canonical_to_number(info.action_information27) tax_rate
               ,info.action_information2 payroll_type
               ,info.action_information28 recalculation
               ,fnd_date.date_to_chardate (fnd_date.canonical_to_date (info.action_information30)) start_date
               ,fnd_date.date_to_chardate (info.effective_date) end_date
               ,fnd_number.canonical_to_number (nvl (info.action_information9
                                                    ,0)) taxable_income_ptd
               ,fnd_number.canonical_to_number (nvl (info.action_information9 + info.action_information10
                                                    ,0)) taxable_income_ytd
               ,fnd_number.canonical_to_number (nvl (info.action_information8
                                                    ,0)) lca_threshold
               ,fnd_number.canonical_to_number (nvl (info.action_information5
                                                    ,0)) lca_payments_ptd
               ,fnd_number.canonical_to_number (nvl (info.action_information6
                                                    ,0)) lca_payments_ytd
               ,fnd_number.canonical_to_number (nvl (info.action_information7
                                                    ,0)) taxable_lca_payments
               ,fnd_number.canonical_to_number (nvl (info.action_information3 + info.action_information4
                                                    ,0)) lca_tax_ytd
               ,fnd_number.canonical_to_number (nvl (info.action_information3
                                                    ,0)) lca_tax_ptd
        FROM    pay_action_information info
               ,pay_payroll_actions generator
               ,pay_payroll_actions datalock
        WHERE   info.action_context_id = generator.payroll_action_id
        AND     info.action_information_category = 'NL_LCA_TAX'
        AND     info.action_information28 = 'N'
        AND     datalock.report_type = 'NL_WAGES_REP_LOCK'
        AND     datalock.business_group_id = :P_BUSINESS_GROUP_ID
        AND     datalock.action_status = 'C'
        AND     to_char (generator.effective_date
                        ,'YYYY') = :P_YEAR
        AND     pay_nl_wage_report_pkg.get_parameters (generator.payroll_action_id
                                                      ,'Legal_Employer') = :P_EMPLOYER_ID
        AND     pay_nl_wage_report_pkg.get_parameters (generator.payroll_action_id
                                                      ,'Payroll_Type') = :P_PAYROLL_TYPE
        AND     pay_nl_wage_report_pkg.get_parameters (datalock.payroll_action_id
                                                      ,'REQUEST_ID') = generator.payroll_action_id
        ORDER BY info.action_information30
Parameter Name SQL text Validation
Employer 
 
 LOV Oracle
Year 
 
 Number
Payroll Type 
 
 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: