ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4715051A9E05362FB09050512 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 Y PAY PAY_NL_LCA_AUDIT US PAY Dutch Labour Cost Agreement Audit 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: BI Publisher :p_business_group_id :p_employer_id :p_payroll_type :p_year 1 -40 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Business Group 2 -30 :p_employer_name Char select substr(NAME,1,150) from hr_organization_units where ORGANIZATION_ID=:$flex$.employer US Employer Name Employer Name 3 -20 :p_payroll_type_name Char select MEANING from hr_lookups where lookup_type = 'NL_WR_PERIOD_TYPE' and lookup_code=:$flex$.payroll_type US Payroll Type Name Payroll Type Name 4 10 :p_employer_id LOV Oracle HR_NL_LEGAL_EMPLOYER Y select hou.organization_id id, hou.name value, null description from hr_organization_units hou where hou.business_group_id=fnd_global.per_business_group_id and exists (select 1 from pay_all_payrolls_f ppf where ppf.business_group_id=fnd_global.per_business_group_id and fnd_number.canonical_to_number(ppf.prl_information1)=hou.organization_id union select 1 from hr_all_organization_units hou1 ,hr_organization_information hoi1 where hou1.business_group_id=fnd_global.per_business_group_id and hoi1.org_information_context='CLASS' and hoi1.org_information1='HR_LEGAL_EMPLOYER' and hou1.organization_id=hoi1.organization_id and hou1.organization_id=hou.organization_id) order by value,description Y US Employer Employer 5 20 :p_year Number select to_char(fs.effective_date,'YYYY') from fnd_sessions fs where fs.session_id = userenv('sessionid') Y US Year Year 6 30 :p_payroll_type LOV Oracle NL_LCA_PERIOD_TYPE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='NL_WR_PERIOD_TYPE' and lookup_code in ('LMONTH','MONTH','WEEK') and enabled_flag='Y' order by value,description Y US Payroll Type Payroll Type :$flex$.employer Employer Employer Name :$flex$.payroll_type Payroll Type Payroll Type Name