ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4714F51A9E05362FB09050512Y 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 PAY PAYUSTOT_XML US PAY GRE Totals 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 BI Publisher :c_business_group_name :c_report_subtitle :c_tax_unit_name :cf_fed_gross_wages :cp_fed_others :cp_fed_status :cp_fit_non_w2_pre_tax_dedns :cp_fit_withheld :cp_fwt_regular_earnings :cp_fwt_supp_earn_fit :cp_fwt_supp_earn_nwfit :cp_medicare_ee_taxable :cp_medicare_ee_withheld :cp_pre_tax_deductions :cp_pre_tax_deductions_for_fit :cp_sit_ee_withheld :cp_ss_ee_taxable :cp_ss_ee_withheld :cp_state_status :cp_state_tax_unit :cp_state_wages_tips_other :p_business_group_id :p_conc_request_id :p_end_date :p_flag :p_report_title :p_session_date :p_start_date :p_start_date_m :p_tax_unit_id 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group ID Business Group ID 2 10 :p_tax_unit_id LOV Oracle HR_US_TAX_UNIT Y select txu.tax_unit_id id, txu.name value, null description from hr_tax_units_v txu where txu.business_group_id= fnd_global.per_business_group_id order by value,description US Government Reporting Entity Government Reporting Entity 3 20 :p_end_date Date Y US As Of Date Date To