Reports2017-11-18T12:27:27+00:00

PAY GRE Totals

Description
Categories: BI Publisher, Human Resources
Application: Payroll
Source: GRE Totals Report (XML)
Short Name: PAYUSTOT_XML
DB package: PAY_PAYUSTOT_XMLP_PKG
SELECT    HOU.ORGANIZATION_ID GRE_ID,
                 HOU.NAME,
                 HOI.ORG_INFORMATION1 Federal_ID,
	PAY_PAYUSTOT_XMLP_PKG.cf_fed_gross_wagesformula(HOU.ORGANIZATION_ID) CF_Fed_Gross_Wages,
	PAY_PAYUSTOT_XMLP_PKG.cf_fed_wages_tips_otherformula(HOU.ORGANIZATION_ID) CF_Fed_Wages_Tips_Other,
	PAY_PAYUSTOT_XMLP_PKG.cf_message_lineformula(:CF_Fed_Gross_Wages) CF_message_line,
	PAY_PAYUSTOT_XMLP_PKG.CP_FED_OTHERS_p CP_FED_OTHERS,
	PAY_PAYUSTOT_XMLP_PKG.CP_FWT_SUPP_EARN_NWFIT_p CP_FWT_SUPP_EARN_NWFIT,
	PAY_PAYUSTOT_XMLP_PKG.CP_FWT_SUPP_EARN_FIT_p CP_FWT_SUPP_EARN_FIT,
	PAY_PAYUSTOT_XMLP_PKG.CP_PRE_TAX_DEDUCTIONS_FOR_P CP_PRE_TAX_DEDUCTIONS_FOR_FIT,
	PAY_PAYUSTOT_XMLP_PKG.CP_FIT_NON_W2_PRE_TAX_DEDNS_p CP_FIT_NON_W2_PRE_TAX_DEDNS,
	PAY_PAYUSTOT_XMLP_PKG.CP_FWT_REGULAR_EARNINGS_p CP_FWT_REGULAR_EARNINGS,
	PAY_PAYUSTOT_XMLP_PKG.CP_PRE_TAX_DEDUCTIONS_p CP_PRE_TAX_DEDUCTIONS,
	PAY_PAYUSTOT_XMLP_PKG.CP_FIT_WITHHELD_p CP_FIT_WITHHELD,
	PAY_PAYUSTOT_XMLP_PKG.CP_SS_EE_TAXABLE_p CP_SS_EE_TAXABLE,
	PAY_PAYUSTOT_XMLP_PKG.CP_SS_EE_WITHHELD_p CP_SS_EE_WITHHELD,
	PAY_PAYUSTOT_XMLP_PKG.CP_MEDICARE_EE_TAXABLE_p CP_MEDICARE_EE_TAXABLE,
	PAY_PAYUSTOT_XMLP_PKG.CP_MEDICARE_EE_WITH_p CP_MEDICARE_EE_WITHHELD,
	'X' Dummy
FROM       HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI
WHERE  HOU.BUSINESS_GROUP_ID=:p_business_group_id
 AND      HOU.ORGANIZATION_ID =  NVL(ltrim(:P_TAX_UNIT_ID), HOU.ORGANIZATION_ID)
 AND   TRUNC(NVL(DATE_TO,:P_END_DATE),'Y')>=TRUNC(:P_END_DATE,'Y')
 AND      HOI.ORGANIZATION_ID=HOU.ORGANIZATION_ID
 AND      HOI.ORG_INFORMATION_CONTEXT='Employer Identification'
ORDER BY HOU.NAME
Parameter Name SQL text Validation
Business Group ID
 
Number
As Of Date
 
Date
Government Reporting Entity
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept