PAY GRE Totals

Description

Imported from BI Publisher
Description: Display GRE Tax Totals prior to Magtape run
Application: Payroll
Source: GRE Totals Report (XML)
Short Name: PAYUSTOT_XML
DB package: PAY_PAYUSTOT_XMLP_PKG

PAY GRE Totals and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

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