PAY Annual FUTA Tax Return (Form 940)

➜ Back to Library
Description
Categories: BI Publisher
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 
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
Parameter Name SQL text Validation
Government Reporting Entity 
 
 LOV Oracle
Tax Year 
 
 Number
State Code 
 
 LOV Oracle
Download
Related Blitz Reports
CAC Internal Order Shipment Margin CAC ICP PII WIP Pending Cost Adjustment CAC Manufacturing Variance Summary PA List Organization Forecast Exceptions CAC Inventory Accounts Setup CAC Inventory to G/L Reconciliation (Restricted by Org Access) CAC Subinventory Accounts Setup CAC WIP Accounts Setup CAC Cost Group Accounts Setup CAC Shipping Network (Inter-Org) Accounts Setup
Blitz Report™

Blitz Report™ provides multiple benefits: