ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4714451A9E05362FB09050512Y SELECT hou.name tax_unit_name , hou.organization_id tax_unit_id , hou.business_group_id business_group_id, PAY_PAYRP940_XMLP_PKG.c_gaz_end_dateformula() C_GAZ_END_DATE, PAY_PAYRP940_XMLP_PKG.c_ny_wagesformula(hou.organization_id,TO_DATE('31-12-' || :P_TAX_YEAR,'DD-MM-YYYY')) C_NY_WAGES, PAY_PAYRP940_XMLP_PKG.c_total_paymentsformula(hou.organization_id,TO_DATE('31-12-' || :P_TAX_YEAR,'DD-MM-YYYY')) C_TOTAL_PAYMENTS, nvl(PAY_PAYRP940_XMLP_PKG.c_total_paymentsformula(hou.organization_id,TO_DATE('31-12-' || :P_TAX_YEAR,'DD-MM-YYYY')),0) C_TOTAL_PAYMENTS1, PAY_PAYRP940_XMLP_PKG.c_ny_rateformula(:C_NY_WAGES) C_NY_RATE, PAY_PAYRP940_XMLP_PKG.c_total_exempt_paymentsformula(hou.organization_id) C_TOTAL_EXEMPT_PAYMENTS, nvl(PAY_PAYRP940_XMLP_PKG.c_total_exempt_paymentsformula(hou.organization_id),0) C_TOTAL_EXEMPT_PAYMENTS1, PAY_PAYRP940_XMLP_PKG.c_total_taxable_wagesformula(:C_TOTAL_PAYMENTS, :C_TOTAL_EXEMPT_PAYMENTS, hou.organization_id) C_TOTAL_TAXABLE_WAGES, PAY_PAYRP940_XMLP_PKG.c_gross_futa_taxformula(:C_TOTAL_TAXABLE_WAGES, hou.organization_id) C_GROSS_FUTA_TAX, PAY_PAYRP940_XMLP_PKG.cf_futa_tax_bef_adjformula(:C_TOTAL_TAXABLE_WAGES) CF_futa_tax_bef_adj, PAY_PAYRP940_XMLP_PKG.c_maximum_creditformula(:C_TOTAL_TAXABLE_WAGES, hou.organization_id) C_MAXIMUM_CREDIT, PAY_PAYRP940_XMLP_PKG.cf_line_9formula(hou.organization_id, TO_DATE('31-12-' || :P_TAX_YEAR,'DD-MM-YYYY'), :C_TOTAL_TAXABLE_WAGES) CF_line_9, PAY_PAYRP940_XMLP_PKG.CP_EXEMPT_PAYMENTS_p CP_EXEMPT_PAYMENTS, PAY_PAYRP940_XMLP_PKG.CP_EXCESS_PAYMENTS_p CP_EXCESS_PAYMENTS FROM hr_organization_units hou WHERE hou.business_group_id +0 = :P_BUSINESS_GROUP_ID AND hou.organization_id = :P_TAX_UNIT_ID PAY PAYRP940_XML US PAY Annual FUTA Tax Return (Form 940) Imported from BI Publisher Description: Annual FUTA Tax Return (Form 940) Application: Payroll Source: Annual FUTA Tax Return (Form 940) (XML) Short Name: PAYRP940_XML DB package: PAY_PAYRP940_XMLP_PKG BI Publisher :c_business_group_name :c_experience_rate2 :c_gaz_start_date :c_ny_wages :c_tax_unit :c_total_exempt_payments :c_total_payments :c_total_taxable_wages :cp_940_fed_status :cp_940_state_status :cp_excess_payments :cp_exempt_payments :cp_from_table :cp_ny_reduction_rate :cp_select_col1 :cp_select_col2 :cp_where_clause :p_business_group_id :p_conc_request_id :p_debug :p_flag :p_state_code :p_tax_unit_id :p_tax_year :p_trace 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Name Business Group ID 2 10 :p_tax_unit_id LOV Oracle HR_US_TAX_GRE Y select tax_unit_id id, name value, null description from hr_tax_units_v where us_1099r_transmitter_code is null and business_group_id=fnd_global.per_business_group_id order by name Y US Government Reporting Entity Tax Unit ID 3 20 :p_tax_year Number Y US Tax Year Year 4 30 :p_state_code LOV Oracle HR_US_STATE_CODE Y select psr.state_code id, psr.state_code value, null description from pay_state_rules psr where exists (select 1 from hr_organization_information hoi2 where hoi2.org_information_context= 'State Tax Rules' and hoi2.organization_id= nvl(:$flex$.hr_us_tax_unit_name:null,hoi2.organization_id)) order by psr.state_code US State Code State Code