PAY Annual FUTA Tax Return (Form 940)

Description
Categories: BI Publisher, Human Resources
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
Business Group Name
 
Number
State Code
 
LOV Oracle
Tax Year
 
Number
Government Reporting Entity
 
LOV Oracle
Ask a question