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.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, 'TOT_EARNING_ASSI_CONCEPTS') TOT_EARNING_ASSI_CONCEPTS, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, '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, fin.effective_date, 'TOT_EXEMPT_EARNINGS') TOT_EXEMPT_EARNINGS, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, 'TOT_NON_CUMULATIVE_EARNINGS') TOT_NON_CUMULATIVE_EARNINGS, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, 'TOT_CUMULATIVE_EARNINGS' ) TOT_CUMULATIVE_EARNINGS, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, 'A_ISR_CALCULATED_PER_PDS_GRE_YTD') ISR_CALCULATED, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, 'ISR_ON_CUMULATIVE_EARNINGS') ISR_ON_CUMULATIVE_EARNINGS, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, '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, fin.effective_date, 'TAX_ON_INCOME_FISCAL_YEAR') TAX_ON_INCOME_FISCAL_YEAR, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, 'ISR_TAX_WITHHELD') ISR_TAX_WITHHELD, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, 'RET_NON_CUMULATIVE_EARNINGS' ) RET_NON_CUMULATIVE_EARNINGS, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, '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, fin.effective_date, 'A_AMENDS_PER_PDS_GRE_YTD' ) AMENDS, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, 'ISR_EXEMPT_FOR_AMENDS' ) ISR_EXEMPT_FOR_AMENDS, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, 'NON_CUMULATIVE_AMENDS' ) NON_CUMULATIVE_AMENDS, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, 'TOTAL_SUBJECT_EARNINGS' ) TOTAL_SUBJECT_EARNINGS, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, 'TOTAL_EXEMPT_EARNINGS') TOTAL_EXEMPT_EARNINGS, pay_mx_yearend_rep.get_f37_balance(fin.payroll_action_id, fin.person_id, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, '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, fin.effective_date, 'A_FORMAT_2D_AID_FOR_PANTRY_AND_FOOD_PER_PDS_GRE_YTD') AID_FOR_PANTRY_AND_FOOD from ( select distinct to_number(pay_mx_isr_format37.get_parameter('TRANSFER_LEGAL_EMPLOYER',ppa.legislative_parameters)) legal_employer_id, ppa.payroll_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.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
, 'TOT_EARNING_ASSI_CONCEPTS') TOT_EARNING_ASSI_CONCEPTS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, 'TOT_EXEMPT_EARNINGS') TOT_EXEMPT_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, 'TOT_NON_CUMULATIVE_EARNINGS') TOT_NON_CUMULATIVE_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, 'TOT_CUMULATIVE_EARNINGS' ) TOT_CUMULATIVE_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, 'A_ISR_CALCULATED_PER_PDS_GRE_YTD') ISR_CALCULATED
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, 'ISR_ON_CUMULATIVE_EARNINGS') ISR_ON_CUMULATIVE_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, 'TAX_ON_INCOME_FISCAL_YEAR') TAX_ON_INCOME_FISCAL_YEAR
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, 'ISR_TAX_WITHHELD') ISR_TAX_WITHHELD
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, 'RET_NON_CUMULATIVE_EARNINGS' ) RET_NON_CUMULATIVE_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, 'A_AMENDS_PER_PDS_GRE_YTD' ) AMENDS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, 'ISR_EXEMPT_FOR_AMENDS' ) ISR_EXEMPT_FOR_AMENDS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, 'NON_CUMULATIVE_AMENDS' ) NON_CUMULATIVE_AMENDS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, 'TOTAL_SUBJECT_EARNINGS' ) TOTAL_SUBJECT_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, 'TOTAL_EXEMPT_EARNINGS') TOTAL_EXEMPT_EARNINGS
, PAY_MX_YEAREND_REP.GET_F37_BALANCE(FIN.PAYROLL_ACTION_ID
, FIN.PERSON_ID
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, '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
, FIN.EFFECTIVE_DATE
, 'A_FORMAT_2D_AID_FOR_PANTRY_AND_FOOD_PER_PDS_GRE_YTD') AID_FOR_PANTRY_AND_FOOD
FROM ( SELECT DISTINCT TO_NUMBER(PAY_MX_ISR_FORMAT37.GET_PARAMETER('TRANSFER_LEGAL_EMPLOYER'
, PPA.LEGISLATIVE_PARAMETERS)) LEGAL_EMPLOYER_ID
, PPA.PAYROLL_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