eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_MX_ISR_TAX_FORMAT37_V

Source

View Text - Preformatted


SELECT fin.legal_employer_id, fin.payroll_action_id, fin.assignment_action_id, fin.effective_date, fin.person_id, fin.fiscal_year_reporting, fin.er_rfc_id, fin.er_legal_name, fin.er_legal_rep_names, fin.er_legal_rep_rfc_id, fin.er_legal_rep_curp, fin.er_tax_subsidy_pct, fin.action_information1 paternal_last_name, fin.action_information2 maternal_last_name, fin.action_information3 names, fin.action_information4 curp, fin.action_information5 rfc_id, fin.action_information6 start_month, fin.action_information7 end_month, fin.action_information8 seniority, fin.action_information9 annual_tax_calc_flag, fin.action_information10 union_worker_flag, fin.action_information11 economic_zone, fin.action_information12 tax_subsidy_pct, fin.action_information13 subsidy_portion_applied, fin.action_information14 other_er_rfc1, fin.action_information15 other_er_rfc2, fin.action_information16 other_er_rfc3, fin.action_information17 other_er_rfc4, fin.action_information18 other_er_rfc5, fin.action_information19 other_er_rfc6, fin.action_information20 other_er_rfc7, fin.action_information21 other_er_rfc8, fin.action_information22 other_er_rfc9, fin.action_information23 other_er_rfc10, fin.action_information26 state_id, fin.action_information28 rate_1991_ind, fin.action_information29 rate_fiscal_year_ind, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fin.effective_date ,'A_FORMAT_37_VOLUNTARY_CONTRIBUTIONS_EE_PER_PDS_GRE_YTD') voluntary_contributions_ee, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fin.effective_date ,'A_FORMAT_37_VOLUNTARY_CONTRIBUTIONS_ER_PER_PDS_GRE_YTD') voluntary_contributions_er, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fin.effective_date ,'A_FORMAT_37_VOLUNTARY_CONTRIBUTIONS_TOTAL_PER_PDS_GRE_YTD') voluntary_contributions_total, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fin.effective_date ,'TOT_DED_VOL_CONTRIBUTION') tot_ded_vol_contribution, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'TOT_EARNING_ASSI_CONCEPTS') tot_earning_assi_concepts, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_EMPLOYEE_STATE_TAX_WITHHELD_PER_PDS_GRE_YTD') employee_state_tax_withheld, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'TOT_EXEMPT_EARNINGS') tot_exempt_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'TOT_NON_CUMULATIVE_EARNINGS') tot_non_cumulative_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'TOT_CUMULATIVE_EARNINGS') tot_cumulative_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_ISR_CALCULATED_PER_PDS_GRE_YTD') isr_calculated, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_ISR_CREDITABLE_SUBSIDY_PER_PDS_GRE_YTD') isr_creditable_subsidy, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_ISR_NON_CREDITABLE_SUBSIDY_PER_PDS_GRE_YTD') isr_non_creditable_subsidy, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_CREDITABLE_SUBSIDY_FRACTIONIII_PER_PDS_GRE_YTD') creditable_subsidy_fractioniii, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_CREDITABLE_SUBSIDY_FRACTIONIV_PER_PDS_GRE_YTD') creditable_subsidy_fractioniv, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'ISR_ON_CUMULATIVE_EARNINGS') isr_on_cumulative_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_ISR_ON_NON_CUMULATIVE_EARNINGS_PER_PDS_GRE_YTD') isr_on_non_cumulative_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'TAX_ON_INCOME_FISCAL_YEAR') tax_on_income_fiscal_year, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'ISR_TAX_WITHHELD') isr_tax_withheld, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_RETIREMENT_EARNINGS_IN_ONE_PAYMENT_PER_PDS_GRE_YTD') ret_earnings_in_one_pymnt, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_RETIREMENT_EARNINGS_IN_PARTIAL_PAYMENTS_PER_PDS_GRE_YTD') ret_earnings_in_part_pymnt, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_RETIREMENT_DAILY_EARNINGS_IN_ONE_PAYMENT_PER_PDS_GRE_YTD') ret_daily_earnings_in_pymnt, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_RETIREMENT_PERIOD_EARNINGS_PER_PDS_GRE_YTD') ret_period_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_RETIREMENT_EARNINGS_DAYS_PER_PDS_GRE_YTD') ret_earnings_days, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_RETIREMENT_EXEMPT_EARNINGS_PER_PDS_GRE_YTD') ret_exempt_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_RETIREMENT_TAXABLE_EARNINGS_PER_PDS_GRE_YTD') ret_taxable_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_RETIREMENT_CUMULATIVE_EARNINGS_PER_PDS_GRE_YTD') ret_cumulative_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'RET_NON_CUMULATIVE_EARNINGS') ret_non_cumulative_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_ISR_WITHHELD_FOR_RETIREMENT_EARNINGS_PER_PDS_GRE_YTD') isr_withheld_for_ret_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_AMENDS_PER_PDS_GRE_YTD') amends, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'ISR_EXEMPT_FOR_AMENDS') isr_exempt_for_amends, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_ISR_SUBJECT_FOR_AMENDS_PER_PDS_GRE_YTD') isr_subject_for_amends, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_LAST_MONTHLY_ORDINARY_SALARY_PER_PDS_GRE_YTD') last_mth_ord_sal, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_LAST_MONTHLY_ORDINARY_SALARY_WITHHELD_PER_PDS_GRE_YTD') last_mth_ord_sal_withheld, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'NON_CUMULATIVE_AMENDS') non_cumulative_amends, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_ISR_WITHHELD_FOR_AMENDS_PER_PDS_GRE_YTD') isr_withheld_for_amends, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_ASSIMILATED_EARNINGS_PER_PDS_GRE_YTD') assimilated_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_ISR_WITHHELD_FOR_ASSIMILATED_EARNINGS_PER_PDS_GRE_YTD') isr_withheld_for_assi_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_STOCK_OPTIONS_VESTING_MARKET_VALUE_PER_PDS_GRE_YTD') stk_options_vesting_value, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_STOCK_OPTIONS_GRANT_PRICE_PER_PDS_GRE_YTD') stk_options_grant_price, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_STOCK_OPTIONS_CUMULATIVE_INCOME_PER_PDS_GRE_YTD') stk_options_cuml_income, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_STOCK_OPTIONS_ISR_WITHHELD_PER_PDS_GRE_YTD') stk_options_tax_withheld, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_FIXED_EARNINGS_PER_PDS_GRE_YTD') isr_exempt_for_fixed_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_FIXED_EARNINGS_PER_PDS_GRE_YTD') isr_subject_for_fixed_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_CHRISTMAS_BONUS_PER_PDS_GRE_YTD') isr_exempt_for_xmas_bonus, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_CHRISTMAS_BONUS_PER_PDS_GRE_YTD') isr_subject_for_xmas_bonus, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_TRAVEL_EXPENSES_PER_PDS_GRE_YTD') isr_exempt_for_travel_exp, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_TRAVEL_EXPENSES_PER_PDS_GRE_YTD') isr_subject_for_travel_exp, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_OVERTIME_PER_PDS_GRE_YTD') isr_exempt_for_overtime, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_OVERTIME_PER_PDS_GRE_YTD') isr_subject_for_overtime, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_VACATION_PREMIUM_PER_PDS_GRE_YTD') isr_exempt_for_vac_premium, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_VACATION_PREMIUM_PER_PDS_GRE_YTD') isr_subject_for_vac_premium, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_DOMINICAL_PREMIUM_PER_PDS_GRE_YTD') isr_exempt_for_dom_premium, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_DOMINICAL_PREMIUM_PER_PDS_GRE_YTD') isr_subject_for_dom_premium, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_PROFIT_SHARING_PER_PDS_GRE_YTD') isr_exempt_for_profit_sharing, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_PROFIT_SHARING_PER_PDS_GRE_YTD') isr_subject_for_profit_sharing, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_HEALTHCARE_REIMBURSEMENT_PER_PDS_GRE_YTD') isr_exempt_for_healthcare_rei, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_HEALTHCARE_REIMBURSEMENT_PER_PDS_GRE_YTD') isr_subject_for_healthcare_rei, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_SAVINGS_FUND_PER_PDS_GRE_YTD') isr_exempt_for_savings_fund, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_SAVINGS_FUND_PER_PDS_GRE_YTD') isr_subject_for_savings_fund, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_SAVINGS_BOX_PER_PDS_GRE_YTD') isr_exempt_for_savings_box, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_SAVINGS_BOX_PER_PDS_GRE_YTD') isr_subject_for_savings_box, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_PANTRY_COUPONS_PER_PDS_GRE_YTD') isr_exempt_for_pantry_coupons, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_PANTRY_COUPONS_PER_PDS_GRE_YTD') isr_subject_for_pantry_coupons, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_FUNERAL_AID_PER_PDS_GRE_YTD') isr_exempt_for_funeral_aid, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_FUNERAL_AID_PER_PDS_GRE_YTD') isr_subject_for_funeral_aid, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_WORKER_CONTRIBUTION_PAID_BY_ER_PER_PDS_GRE_YTD') isr_exempt_for_wr_pd_by_er, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_WORKER_CONTRIBUTION_PAID_BY_ER_PER_PDS_GRE_YTD') isr_subject_for_wr_pd_by_er, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_PUNCTUALITY_INCENTIVE_PER_PDS_GRE_YTD') isr_exempt_for_pun_incentive, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_PUNCTUALITY_INCENTIVE_PER_PDS_GRE_YTD') isr_subject_for_pun_incentive, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_LIFE_INSURANCE_PREMIUM_PER_PDS_GRE_YTD') isr_exempt_for_life_ins_pre, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_LIFE_INSURANCE_PREMIUM_PER_PDS_GRE_YTD') isr_subject_for_life_ins_pre, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_MAJOR_MEDICAL_EXPENSE_INSURANCE_PER_PDS_GRE_YTD') isr_exempt_for_major_med_ins, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_MAJOR_MEDICAL_EXPENSE_INSURANCE_PER_PDS_GRE_YTD') isr_subject_for_major_med_ins, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_RESTAURANT_COUPONS_PER_PDS_GRE_YTD') isr_exempt_for_rest_coupons, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_RESTAURANT_COUPONS_PER_PDS_GRE_YTD') isr_subject_for_rest_coupons, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_GASOLINE_COUPONS_PER_PDS_GRE_YTD') isr_exempt_for_gas_coupons, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_GASOLINE_COUPONS_PER_PDS_GRE_YTD') isr_subject_for_gas_coupons, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_UNIFORM_COUPONS_PER_PDS_GRE_YTD') isr_exempt_for_uni_coupons, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_UNIFORM_COUPONS_PER_PDS_GRE_YTD') isr_subject_for_uni_coupons, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_RENTAL_AID_PER_PDS_GRE_YTD') isr_exempt_for_rental_aid, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_RENTAL_AID_PER_PDS_GRE_YTD') isr_subject_for_rental_aid, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_EDUCATIONAL_AID_PER_PDS_GRE_YTD') isr_exempt_for_edu_aid, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_EDUCATIONAL_AID_PER_PDS_GRE_YTD') isr_subject_for_edu_aid, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_GLASSES_AID_PER_PDS_GRE_YTD') isr_subject_for_glasses_aid, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_GLASSES_AID_PER_PDS_GRE_YTD') isr_exempt_for_glasses_aid, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_TRANSPORTATION_AID_PER_PDS_GRE_YTD') isr_exempt_for_trans_aid, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_TRANSPORTATION_AID_PER_PDS_GRE_YTD') isr_subject_for_trans_aid, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_UNION_QUOTA_PAID_BY_ER_PER_PDS_GRE_YTD') isr_exempt_for_union_pd_by_er, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_UNION_QUOTA_PAID_BY_ER_PER_PDS_GRE_YTD') isr_subject_for_union_pd_by_er, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_DISABILITIES_SUBSIDY_PER_PDS_GRE_YTD') isr_exempt_for_disab_subsidy, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_DISABILITIES_SUBSIDY_PER_PDS_GRE_YTD') isr_subject_for_disab_subsidy, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_EXEMPT_FOR_CHILDREN_SCHOLARSHIP_PER_PDS_GRE_YTD') isr_exempt_for_child_scholar, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_YEAR_END_ISR_SUBJECT_FOR_CHILDREN_SCHOLARSHIP_PER_PDS_GRE_YTD') isr_subject_for_child_scholar, decode(nvl(fin.action_information9 ,'N') ,'Y' ,fin.action_information24 ,0) prev_er_earnings, decode(nvl(fin.action_information9 ,'N') ,'Y' ,fin.action_information27 ,0) prev_er_exempt_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_ISR_EXEMPT_FOR_OTHER_INCOME_PER_PDS_GRE_YTD') isr_exempt_other_income, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_ISR_SUBJECT_FOR_OTHER_INCOME_PER_PDS_GRE_YTD') isr_subject_other_income, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'TOTAL_SUBJECT_EARNINGS') total_subject_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'TOTAL_EXEMPT_EARNINGS') total_exempt_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'TAX_WITHHELD_IN_FISCAL_YEAR') tax_withheld_in_fiscal_year, decode(nvl(fin.action_information9 ,'N') ,'Y' ,fin.action_information25 ,0) prev_er_isr_withheld, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_CURRENT_FISCAL_YEAR_ARREARS_PER_PDS_GRE_YTD') current_fy_arrears, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_PREVIOUS_FISCAL_YEAR_ARREARS_PER_PDS_GRE_YTD') prev_fy_arrears, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_ISR_CREDIT_TO_SALARY_PER_PDS_GRE_YTD') credit_to_salary, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_ISR_CREDIT_TO_SALARY_PAID_PER_PDS_GRE_YTD') credit_to_salary_paid, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_SOCIAL_FORESIGHT_EARNINGS_PER_PDS_GRE_YTD') social_foresight_earnings, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_37_ISR_EXEMPT_FOR_SOCIAL_FORESIGHT_EARNINGS_PER_PDS_GRE_YTD') isr_exempt_for_soc_foresight, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_FORMAT_2D_AID_FOR_PANTRY_AND_FOOD_PER_PDS_GRE_YTD') aid_for_pantry_and_food, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_ISR_SUBSIDY_FOR_EMPLOYMENT_PER_PDS_GRE_YTD') isr_subsidy_for_emp, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_ISR_SUBSIDY_FOR_EMPLOYMENT_PAID_PER_PDS_GRE_YTD') isr_subsidy_for_emp_paid, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id ,fin.person_id ,fnd_date.canonical_to_date(fin.action_information7) ,'A_ISR_TAX_TO_CHARGE_PER_PDS_GRE_YTD') isr_tax_to_charge FROM (SELECT DISTINCT to_number(pay_mx_isr_format37.get_parameter('TRANSFER_LEGAL_EMPLOYER' ,ppa.legislative_parameters)) legal_employer_id, ppa.payroll_action_id, paa.assignment_action_id, pai.effective_date, paa.serial_number person_id, pai1.action_information1 fiscal_year_reporting, pai1.action_information2 er_rfc_id, pai1.action_information3 er_legal_name, pai1.action_information4 er_legal_rep_names, pai1.action_information5 er_legal_rep_rfc_id, pai1.action_information6 er_legal_rep_curp, pai1.action_information7 er_tax_subsidy_pct, pai.action_information1, pai.action_information2, pai.action_information3, pai.action_information4, pai.action_information5, pai.action_information6, pai.action_information7, pai.action_information8, pai.action_information9, pai.action_information10, pai.action_information11, pai.action_information12, pai.action_information13, pai.action_information14, pai.action_information15, pai.action_information16, pai.action_information17, pai.action_information18, pai.action_information19, pai.action_information20, pai.action_information21, pai.action_information22, pai.action_information23, pai.action_information24, pai.action_information25, pai.action_information26, pai.action_information27, pai.action_information28, pai.action_information29 FROM pay_payroll_actions ppa, pay_assignment_actions paa, pay_action_information pai, pay_action_information pai1 WHERE ppa.report_type = 'MX_YREND_ARCHIVE' AND ppa.action_status = 'C' AND ppa.payroll_action_id = paa.payroll_action_id AND pai.action_context_id = paa.assignment_action_id AND pai.action_information_category = 'MX YREND EE DETAILS' AND pai1.action_context_id = ppa.payroll_action_id AND pai1.action_information_category = 'MX YREND LEGAL ER DETAILS' ) fin

View Text - HTML Formatted

SELECT FIN.LEGAL_EMPLOYER_ID
, FIN.PAYROLL_ACTION_ID
, FIN.ASSIGNMENT_ACTION_ID
, FIN.EFFECTIVE_DATE
, FIN.PERSON_ID
, FIN.FISCAL_YEAR_REPORTING
, FIN.ER_RFC_ID
, FIN.ER_LEGAL_NAME
, FIN.ER_LEGAL_REP_NAMES
, FIN.ER_LEGAL_REP_RFC_ID
, FIN.ER_LEGAL_REP_CURP
, FIN.ER_TAX_SUBSIDY_PCT
, FIN.ACTION_INFORMATION1 PATERNAL_LAST_NAME
, FIN.ACTION_INFORMATION2 MATERNAL_LAST_NAME
, FIN.ACTION_INFORMATION3 NAMES
, FIN.ACTION_INFORMATION4 CURP
, FIN.ACTION_INFORMATION5 RFC_ID
, FIN.ACTION_INFORMATION6 START_MONTH
, FIN.ACTION_INFORMATION7 END_MONTH
, FIN.ACTION_INFORMATION8 SENIORITY
, FIN.ACTION_INFORMATION9 ANNUAL_TAX_CALC_FLAG
, FIN.ACTION_INFORMATION10 UNION_WORKER_FLAG
, FIN.ACTION_INFORMATION11 ECONOMIC_ZONE
, FIN.ACTION_INFORMATION12 TAX_SUBSIDY_PCT
, FIN.ACTION_INFORMATION13 SUBSIDY_PORTION_APPLIED
, FIN.ACTION_INFORMATION14 OTHER_ER_RFC1
, FIN.ACTION_INFORMATION15 OTHER_ER_RFC2
, FIN.ACTION_INFORMATION16 OTHER_ER_RFC3
, FIN.ACTION_INFORMATION17 OTHER_ER_RFC4
, FIN.ACTION_INFORMATION18 OTHER_ER_RFC5
, FIN.ACTION_INFORMATION19 OTHER_ER_RFC6
, FIN.ACTION_INFORMATION20 OTHER_ER_RFC7
, FIN.ACTION_INFORMATION21 OTHER_ER_RFC8
, FIN.ACTION_INFORMATION22 OTHER_ER_RFC9
, FIN.ACTION_INFORMATION23 OTHER_ER_RFC10
, FIN.ACTION_INFORMATION26 STATE_ID
, FIN.ACTION_INFORMATION28 RATE_1991_IND
, FIN.ACTION_INFORMATION29 RATE_FISCAL_YEAR_IND
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, 'A_FORMAT_37_VOLUNTARY_CONTRIBUTIONS_EE_PER_PDS_GRE_YTD') VOLUNTARY_CONTRIBUTIONS_EE
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, 'A_FORMAT_37_VOLUNTARY_CONTRIBUTIONS_ER_PER_PDS_GRE_YTD') VOLUNTARY_CONTRIBUTIONS_ER
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, 'A_FORMAT_37_VOLUNTARY_CONTRIBUTIONS_TOTAL_PER_PDS_GRE_YTD') VOLUNTARY_CONTRIBUTIONS_TOTAL
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, 'TOT_DED_VOL_CONTRIBUTION') TOT_DED_VOL_CONTRIBUTION
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'TOT_EARNING_ASSI_CONCEPTS') TOT_EARNING_ASSI_CONCEPTS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_EMPLOYEE_STATE_TAX_WITHHELD_PER_PDS_GRE_YTD') EMPLOYEE_STATE_TAX_WITHHELD
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'TOT_EXEMPT_EARNINGS') TOT_EXEMPT_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'TOT_NON_CUMULATIVE_EARNINGS') TOT_NON_CUMULATIVE_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'TOT_CUMULATIVE_EARNINGS') TOT_CUMULATIVE_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_ISR_CALCULATED_PER_PDS_GRE_YTD') ISR_CALCULATED
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_ISR_CREDITABLE_SUBSIDY_PER_PDS_GRE_YTD') ISR_CREDITABLE_SUBSIDY
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_ISR_NON_CREDITABLE_SUBSIDY_PER_PDS_GRE_YTD') ISR_NON_CREDITABLE_SUBSIDY
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_CREDITABLE_SUBSIDY_FRACTIONIII_PER_PDS_GRE_YTD') CREDITABLE_SUBSIDY_FRACTIONIII
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_CREDITABLE_SUBSIDY_FRACTIONIV_PER_PDS_GRE_YTD') CREDITABLE_SUBSIDY_FRACTIONIV
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'ISR_ON_CUMULATIVE_EARNINGS') ISR_ON_CUMULATIVE_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_ISR_ON_NON_CUMULATIVE_EARNINGS_PER_PDS_GRE_YTD') ISR_ON_NON_CUMULATIVE_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'TAX_ON_INCOME_FISCAL_YEAR') TAX_ON_INCOME_FISCAL_YEAR
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'ISR_TAX_WITHHELD') ISR_TAX_WITHHELD
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_RETIREMENT_EARNINGS_IN_ONE_PAYMENT_PER_PDS_GRE_YTD') RET_EARNINGS_IN_ONE_PYMNT
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_RETIREMENT_EARNINGS_IN_PARTIAL_PAYMENTS_PER_PDS_GRE_YTD') RET_EARNINGS_IN_PART_PYMNT
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_RETIREMENT_DAILY_EARNINGS_IN_ONE_PAYMENT_PER_PDS_GRE_YTD') RET_DAILY_EARNINGS_IN_PYMNT
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_RETIREMENT_PERIOD_EARNINGS_PER_PDS_GRE_YTD') RET_PERIOD_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_RETIREMENT_EARNINGS_DAYS_PER_PDS_GRE_YTD') RET_EARNINGS_DAYS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_RETIREMENT_EXEMPT_EARNINGS_PER_PDS_GRE_YTD') RET_EXEMPT_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_RETIREMENT_TAXABLE_EARNINGS_PER_PDS_GRE_YTD') RET_TAXABLE_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_RETIREMENT_CUMULATIVE_EARNINGS_PER_PDS_GRE_YTD') RET_CUMULATIVE_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'RET_NON_CUMULATIVE_EARNINGS') RET_NON_CUMULATIVE_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_ISR_WITHHELD_FOR_RETIREMENT_EARNINGS_PER_PDS_GRE_YTD') ISR_WITHHELD_FOR_RET_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_AMENDS_PER_PDS_GRE_YTD') AMENDS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'ISR_EXEMPT_FOR_AMENDS') ISR_EXEMPT_FOR_AMENDS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_ISR_SUBJECT_FOR_AMENDS_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_AMENDS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_LAST_MONTHLY_ORDINARY_SALARY_PER_PDS_GRE_YTD') LAST_MTH_ORD_SAL
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_LAST_MONTHLY_ORDINARY_SALARY_WITHHELD_PER_PDS_GRE_YTD') LAST_MTH_ORD_SAL_WITHHELD
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'NON_CUMULATIVE_AMENDS') NON_CUMULATIVE_AMENDS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_ISR_WITHHELD_FOR_AMENDS_PER_PDS_GRE_YTD') ISR_WITHHELD_FOR_AMENDS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_ASSIMILATED_EARNINGS_PER_PDS_GRE_YTD') ASSIMILATED_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_ISR_WITHHELD_FOR_ASSIMILATED_EARNINGS_PER_PDS_GRE_YTD') ISR_WITHHELD_FOR_ASSI_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_STOCK_OPTIONS_VESTING_MARKET_VALUE_PER_PDS_GRE_YTD') STK_OPTIONS_VESTING_VALUE
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_STOCK_OPTIONS_GRANT_PRICE_PER_PDS_GRE_YTD') STK_OPTIONS_GRANT_PRICE
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_STOCK_OPTIONS_CUMULATIVE_INCOME_PER_PDS_GRE_YTD') STK_OPTIONS_CUML_INCOME
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_STOCK_OPTIONS_ISR_WITHHELD_PER_PDS_GRE_YTD') STK_OPTIONS_TAX_WITHHELD
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_FIXED_EARNINGS_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_FIXED_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_FIXED_EARNINGS_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_FIXED_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_CHRISTMAS_BONUS_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_XMAS_BONUS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_CHRISTMAS_BONUS_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_XMAS_BONUS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_TRAVEL_EXPENSES_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_TRAVEL_EXP
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_TRAVEL_EXPENSES_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_TRAVEL_EXP
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_OVERTIME_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_OVERTIME
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_OVERTIME_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_OVERTIME
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_VACATION_PREMIUM_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_VAC_PREMIUM
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_VACATION_PREMIUM_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_VAC_PREMIUM
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_DOMINICAL_PREMIUM_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_DOM_PREMIUM
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_DOMINICAL_PREMIUM_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_DOM_PREMIUM
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_PROFIT_SHARING_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_PROFIT_SHARING
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_PROFIT_SHARING_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_PROFIT_SHARING
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_HEALTHCARE_REIMBURSEMENT_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_HEALTHCARE_REI
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_HEALTHCARE_REIMBURSEMENT_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_HEALTHCARE_REI
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_SAVINGS_FUND_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_SAVINGS_FUND
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_SAVINGS_FUND_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_SAVINGS_FUND
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_SAVINGS_BOX_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_SAVINGS_BOX
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_SAVINGS_BOX_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_SAVINGS_BOX
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_PANTRY_COUPONS_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_PANTRY_COUPONS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_PANTRY_COUPONS_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_PANTRY_COUPONS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_FUNERAL_AID_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_FUNERAL_AID
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_FUNERAL_AID_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_FUNERAL_AID
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_WORKER_CONTRIBUTION_PAID_BY_ER_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_WR_PD_BY_ER
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_WORKER_CONTRIBUTION_PAID_BY_ER_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_WR_PD_BY_ER
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_PUNCTUALITY_INCENTIVE_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_PUN_INCENTIVE
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_PUNCTUALITY_INCENTIVE_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_PUN_INCENTIVE
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_LIFE_INSURANCE_PREMIUM_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_LIFE_INS_PRE
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_LIFE_INSURANCE_PREMIUM_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_LIFE_INS_PRE
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_MAJOR_MEDICAL_EXPENSE_INSURANCE_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_MAJOR_MED_INS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_MAJOR_MEDICAL_EXPENSE_INSURANCE_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_MAJOR_MED_INS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_RESTAURANT_COUPONS_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_REST_COUPONS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_RESTAURANT_COUPONS_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_REST_COUPONS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_GASOLINE_COUPONS_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_GAS_COUPONS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_GASOLINE_COUPONS_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_GAS_COUPONS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_UNIFORM_COUPONS_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_UNI_COUPONS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_UNIFORM_COUPONS_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_UNI_COUPONS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_RENTAL_AID_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_RENTAL_AID
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_RENTAL_AID_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_RENTAL_AID
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_EDUCATIONAL_AID_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_EDU_AID
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_EDUCATIONAL_AID_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_EDU_AID
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_GLASSES_AID_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_GLASSES_AID
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_GLASSES_AID_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_GLASSES_AID
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_TRANSPORTATION_AID_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_TRANS_AID
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_TRANSPORTATION_AID_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_TRANS_AID
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_UNION_QUOTA_PAID_BY_ER_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_UNION_PD_BY_ER
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_UNION_QUOTA_PAID_BY_ER_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_UNION_PD_BY_ER
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_DISABILITIES_SUBSIDY_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_DISAB_SUBSIDY
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_DISABILITIES_SUBSIDY_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_DISAB_SUBSIDY
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_EXEMPT_FOR_CHILDREN_SCHOLARSHIP_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_CHILD_SCHOLAR
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_YEAR_END_ISR_SUBJECT_FOR_CHILDREN_SCHOLARSHIP_PER_PDS_GRE_YTD') ISR_SUBJECT_FOR_CHILD_SCHOLAR
, DECODE(NVL(FIN.ACTION_INFORMATION9
, 'N')
, 'Y'
, FIN.ACTION_INFORMATION24
, 0) PREV_ER_EARNINGS
, DECODE(NVL(FIN.ACTION_INFORMATION9
, 'N')
, 'Y'
, FIN.ACTION_INFORMATION27
, 0) PREV_ER_EXEMPT_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_ISR_EXEMPT_FOR_OTHER_INCOME_PER_PDS_GRE_YTD') ISR_EXEMPT_OTHER_INCOME
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_ISR_SUBJECT_FOR_OTHER_INCOME_PER_PDS_GRE_YTD') ISR_SUBJECT_OTHER_INCOME
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'TOTAL_SUBJECT_EARNINGS') TOTAL_SUBJECT_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'TOTAL_EXEMPT_EARNINGS') TOTAL_EXEMPT_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'TAX_WITHHELD_IN_FISCAL_YEAR') TAX_WITHHELD_IN_FISCAL_YEAR
, DECODE(NVL(FIN.ACTION_INFORMATION9
, 'N')
, 'Y'
, FIN.ACTION_INFORMATION25
, 0) PREV_ER_ISR_WITHHELD
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_CURRENT_FISCAL_YEAR_ARREARS_PER_PDS_GRE_YTD') CURRENT_FY_ARREARS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_PREVIOUS_FISCAL_YEAR_ARREARS_PER_PDS_GRE_YTD') PREV_FY_ARREARS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_ISR_CREDIT_TO_SALARY_PER_PDS_GRE_YTD') CREDIT_TO_SALARY
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_ISR_CREDIT_TO_SALARY_PAID_PER_PDS_GRE_YTD') CREDIT_TO_SALARY_PAID
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_SOCIAL_FORESIGHT_EARNINGS_PER_PDS_GRE_YTD') SOCIAL_FORESIGHT_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_37_ISR_EXEMPT_FOR_SOCIAL_FORESIGHT_EARNINGS_PER_PDS_GRE_YTD') ISR_EXEMPT_FOR_SOC_FORESIGHT
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_FORMAT_2D_AID_FOR_PANTRY_AND_FOOD_PER_PDS_GRE_YTD') AID_FOR_PANTRY_AND_FOOD
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_ISR_SUBSIDY_FOR_EMPLOYMENT_PER_PDS_GRE_YTD') ISR_SUBSIDY_FOR_EMP
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_ISR_SUBSIDY_FOR_EMPLOYMENT_PAID_PER_PDS_GRE_YTD') ISR_SUBSIDY_FOR_EMP_PAID
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(FIN.ACTION_INFORMATION7)
, 'A_ISR_TAX_TO_CHARGE_PER_PDS_GRE_YTD') ISR_TAX_TO_CHARGE
FROM (SELECT DISTINCT TO_NUMBER(PAY_MX_ISR_FORMAT37.GET_PARAMETER('TRANSFER_LEGAL_EMPLOYER'
, PPA.LEGISLATIVE_PARAMETERS)) LEGAL_EMPLOYER_ID
, PPA.PAYROLL_ACTION_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAI.EFFECTIVE_DATE
, PAA.SERIAL_NUMBER PERSON_ID
, PAI1.ACTION_INFORMATION1 FISCAL_YEAR_REPORTING
, PAI1.ACTION_INFORMATION2 ER_RFC_ID
, PAI1.ACTION_INFORMATION3 ER_LEGAL_NAME
, PAI1.ACTION_INFORMATION4 ER_LEGAL_REP_NAMES
, PAI1.ACTION_INFORMATION5 ER_LEGAL_REP_RFC_ID
, PAI1.ACTION_INFORMATION6 ER_LEGAL_REP_CURP
, PAI1.ACTION_INFORMATION7 ER_TAX_SUBSIDY_PCT
, PAI.ACTION_INFORMATION1
, PAI.ACTION_INFORMATION2
, PAI.ACTION_INFORMATION3
, PAI.ACTION_INFORMATION4
, PAI.ACTION_INFORMATION5
, PAI.ACTION_INFORMATION6
, PAI.ACTION_INFORMATION7
, PAI.ACTION_INFORMATION8
, PAI.ACTION_INFORMATION9
, PAI.ACTION_INFORMATION10
, PAI.ACTION_INFORMATION11
, PAI.ACTION_INFORMATION12
, PAI.ACTION_INFORMATION13
, PAI.ACTION_INFORMATION14
, PAI.ACTION_INFORMATION15
, PAI.ACTION_INFORMATION16
, PAI.ACTION_INFORMATION17
, PAI.ACTION_INFORMATION18
, PAI.ACTION_INFORMATION19
, PAI.ACTION_INFORMATION20
, PAI.ACTION_INFORMATION21
, PAI.ACTION_INFORMATION22
, PAI.ACTION_INFORMATION23
, PAI.ACTION_INFORMATION24
, PAI.ACTION_INFORMATION25
, PAI.ACTION_INFORMATION26
, PAI.ACTION_INFORMATION27
, PAI.ACTION_INFORMATION28
, PAI.ACTION_INFORMATION29
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_ACTION_INFORMATION PAI
, PAY_ACTION_INFORMATION PAI1
WHERE PPA.REPORT_TYPE = 'MX_YREND_ARCHIVE'
AND PPA.ACTION_STATUS = 'C'
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAI.ACTION_INFORMATION_CATEGORY = 'MX YREND EE DETAILS'
AND PAI1.ACTION_CONTEXT_ID = PPA.PAYROLL_ACTION_ID
AND PAI1.ACTION_INFORMATION_CATEGORY = 'MX YREND LEGAL ER DETAILS' ) FIN