PAY Dutch Labour Cost Agreement Audit

         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