DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PAY_MX_ISR_TAX_FORMAT37_V

Object Details
Object Name: PAY_MX_ISR_TAX_FORMAT37_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
LEGAL_EMPLOYER_ID NUMBER

PAYROLL_ACTION_ID NUMBER (9) Yes
ASSIGNMENT_ACTION_ID NUMBER (15) Yes
EFFECTIVE_DATE DATE

PERSON_ID VARCHAR2 (30)
FISCAL_YEAR_REPORTING VARCHAR2 (240)
ER_RFC_ID VARCHAR2 (240)
ER_LEGAL_NAME VARCHAR2 (240)
ER_LEGAL_REP_NAMES VARCHAR2 (240)
ER_LEGAL_REP_RFC_ID VARCHAR2 (240)
ER_LEGAL_REP_CURP VARCHAR2 (240)
ER_TAX_SUBSIDY_PCT VARCHAR2 (240)
PATERNAL_LAST_NAME VARCHAR2 (240)
MATERNAL_LAST_NAME VARCHAR2 (240)
NAMES VARCHAR2 (240)
CURP VARCHAR2 (240)
RFC_ID VARCHAR2 (240)
START_MONTH VARCHAR2 (240)
END_MONTH VARCHAR2 (240)
SENIORITY VARCHAR2 (240)
ANNUAL_TAX_CALC_FLAG VARCHAR2 (240)
UNION_WORKER_FLAG VARCHAR2 (240)
ECONOMIC_ZONE VARCHAR2 (240)
TAX_SUBSIDY_PCT VARCHAR2 (240)
SUBSIDY_PORTION_APPLIED VARCHAR2 (240)
OTHER_ER_RFC1 VARCHAR2 (240)
OTHER_ER_RFC2 VARCHAR2 (240)
OTHER_ER_RFC3 VARCHAR2 (240)
OTHER_ER_RFC4 VARCHAR2 (240)
OTHER_ER_RFC5 VARCHAR2 (240)
OTHER_ER_RFC6 VARCHAR2 (240)
OTHER_ER_RFC7 VARCHAR2 (240)
OTHER_ER_RFC8 VARCHAR2 (240)
OTHER_ER_RFC9 VARCHAR2 (240)
OTHER_ER_RFC10 VARCHAR2 (240)
STATE_ID VARCHAR2 (240)
RATE_1991_IND VARCHAR2 (240)
RATE_FISCAL_YEAR_IND VARCHAR2 (240)
VOLUNTARY_CONTRIBUTIONS_EE NUMBER

VOLUNTARY_CONTRIBUTIONS_ER NUMBER

VOLUNTARY_CONTRIBUTIONS_TOTAL NUMBER

TOT_DED_VOL_CONTRIBUTION NUMBER

TOT_EARNING_ASSI_CONCEPTS NUMBER

EMPLOYEE_STATE_TAX_WITHHELD NUMBER

TOT_EXEMPT_EARNINGS NUMBER

TOT_NON_CUMULATIVE_EARNINGS NUMBER

TOT_CUMULATIVE_EARNINGS NUMBER

ISR_CALCULATED NUMBER

ISR_CREDITABLE_SUBSIDY NUMBER

ISR_NON_CREDITABLE_SUBSIDY NUMBER

CREDITABLE_SUBSIDY_FRACTIONIII NUMBER

CREDITABLE_SUBSIDY_FRACTIONIV NUMBER

ISR_ON_CUMULATIVE_EARNINGS NUMBER

ISR_ON_NON_CUMULATIVE_EARNINGS NUMBER

TAX_ON_INCOME_FISCAL_YEAR NUMBER

ISR_TAX_WITHHELD NUMBER

RET_EARNINGS_IN_ONE_PYMNT NUMBER

RET_EARNINGS_IN_PART_PYMNT NUMBER

RET_DAILY_EARNINGS_IN_PYMNT NUMBER

RET_PERIOD_EARNINGS NUMBER

RET_EARNINGS_DAYS NUMBER

RET_EXEMPT_EARNINGS NUMBER

RET_TAXABLE_EARNINGS NUMBER

RET_CUMULATIVE_EARNINGS NUMBER

RET_NON_CUMULATIVE_EARNINGS NUMBER

ISR_WITHHELD_FOR_RET_EARNINGS NUMBER

AMENDS NUMBER

ISR_EXEMPT_FOR_AMENDS NUMBER

ISR_SUBJECT_FOR_AMENDS NUMBER

LAST_MTH_ORD_SAL NUMBER

LAST_MTH_ORD_SAL_WITHHELD NUMBER

NON_CUMULATIVE_AMENDS NUMBER

ISR_WITHHELD_FOR_AMENDS NUMBER

ASSIMILATED_EARNINGS NUMBER

ISR_WITHHELD_FOR_ASSI_EARNINGS NUMBER

STK_OPTIONS_VESTING_VALUE NUMBER

STK_OPTIONS_GRANT_PRICE NUMBER

STK_OPTIONS_CUML_INCOME NUMBER

STK_OPTIONS_TAX_WITHHELD NUMBER

ISR_EXEMPT_FOR_FIXED_EARNINGS NUMBER

ISR_SUBJECT_FOR_FIXED_EARNINGS NUMBER

ISR_EXEMPT_FOR_XMAS_BONUS NUMBER

ISR_SUBJECT_FOR_XMAS_BONUS NUMBER

ISR_EXEMPT_FOR_TRAVEL_EXP NUMBER

ISR_SUBJECT_FOR_TRAVEL_EXP NUMBER

ISR_EXEMPT_FOR_OVERTIME NUMBER

ISR_SUBJECT_FOR_OVERTIME NUMBER

ISR_EXEMPT_FOR_VAC_PREMIUM NUMBER

ISR_SUBJECT_FOR_VAC_PREMIUM NUMBER

ISR_EXEMPT_FOR_DOM_PREMIUM NUMBER

ISR_SUBJECT_FOR_DOM_PREMIUM NUMBER

ISR_EXEMPT_FOR_PROFIT_SHARING NUMBER

ISR_SUBJECT_FOR_PROFIT_SHARING NUMBER

ISR_EXEMPT_FOR_HEALTHCARE_REI NUMBER

ISR_SUBJECT_FOR_HEALTHCARE_REI NUMBER

ISR_EXEMPT_FOR_SAVINGS_FUND NUMBER

ISR_SUBJECT_FOR_SAVINGS_FUND NUMBER

ISR_EXEMPT_FOR_SAVINGS_BOX NUMBER

ISR_SUBJECT_FOR_SAVINGS_BOX NUMBER

ISR_EXEMPT_FOR_PANTRY_COUPONS NUMBER

ISR_SUBJECT_FOR_PANTRY_COUPONS NUMBER

ISR_EXEMPT_FOR_FUNERAL_AID NUMBER

ISR_SUBJECT_FOR_FUNERAL_AID NUMBER

ISR_EXEMPT_FOR_WR_PD_BY_ER NUMBER

ISR_SUBJECT_FOR_WR_PD_BY_ER NUMBER

ISR_EXEMPT_FOR_PUN_INCENTIVE NUMBER

ISR_SUBJECT_FOR_PUN_INCENTIVE NUMBER

ISR_EXEMPT_FOR_LIFE_INS_PRE NUMBER

ISR_SUBJECT_FOR_LIFE_INS_PRE NUMBER

ISR_EXEMPT_FOR_MAJOR_MED_INS NUMBER

ISR_SUBJECT_FOR_MAJOR_MED_INS NUMBER

ISR_EXEMPT_FOR_REST_COUPONS NUMBER

ISR_SUBJECT_FOR_REST_COUPONS NUMBER

ISR_EXEMPT_FOR_GAS_COUPONS NUMBER

ISR_SUBJECT_FOR_GAS_COUPONS NUMBER

ISR_EXEMPT_FOR_UNI_COUPONS NUMBER

ISR_SUBJECT_FOR_UNI_COUPONS NUMBER

ISR_EXEMPT_FOR_RENTAL_AID NUMBER

ISR_SUBJECT_FOR_RENTAL_AID NUMBER

ISR_EXEMPT_FOR_EDU_AID NUMBER

ISR_SUBJECT_FOR_EDU_AID NUMBER

ISR_EXEMPT_FOR_GLASSES_AID NUMBER

ISR_SUBJECT_FOR_GLASSES_AID NUMBER

ISR_EXEMPT_FOR_TRANS_AID NUMBER

ISR_SUBJECT_FOR_TRANS_AID NUMBER

ISR_EXEMPT_FOR_UNION_PD_BY_ER NUMBER

ISR_SUBJECT_FOR_UNION_PD_BY_ER NUMBER

ISR_EXEMPT_FOR_DISAB_SUBSIDY NUMBER

ISR_SUBJECT_FOR_DISAB_SUBSIDY NUMBER

ISR_EXEMPT_FOR_CHILD_SCHOLAR NUMBER

ISR_SUBJECT_FOR_CHILD_SCHOLAR NUMBER

PREV_ER_EARNINGS VARCHAR2 (240)
PREV_ER_EXEMPT_EARNINGS VARCHAR2 (240)
ISR_EXEMPT_OTHER_INCOME NUMBER

ISR_SUBJECT_OTHER_INCOME NUMBER

TOTAL_SUBJECT_EARNINGS NUMBER

TOTAL_EXEMPT_EARNINGS NUMBER

TAX_WITHHELD_IN_FISCAL_YEAR NUMBER

PREV_ER_ISR_WITHHELD VARCHAR2 (240)
CURRENT_FY_ARREARS NUMBER

PREV_FY_ARREARS NUMBER

CREDIT_TO_SALARY NUMBER

CREDIT_TO_SALARY_PAID NUMBER

SOCIAL_FORESIGHT_EARNINGS NUMBER

ISR_EXEMPT_FOR_SOC_FORESIGHT NUMBER

AID_FOR_PANTRY_AND_FOOD NUMBER

ISR_SUBSIDY_FOR_EMP NUMBER

ISR_SUBSIDY_FOR_EMP_PAID NUMBER

ISR_TAX_TO_CHARGE NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LEGAL_EMPLOYER_ID
,      PAYROLL_ACTION_ID
,      ASSIGNMENT_ACTION_ID
,      EFFECTIVE_DATE
,      PERSON_ID
,      FISCAL_YEAR_REPORTING
,      ER_RFC_ID
,      ER_LEGAL_NAME
,      ER_LEGAL_REP_NAMES
,      ER_LEGAL_REP_RFC_ID
,      ER_LEGAL_REP_CURP
,      ER_TAX_SUBSIDY_PCT
,      PATERNAL_LAST_NAME
,      MATERNAL_LAST_NAME
,      NAMES
,      CURP
,      RFC_ID
,      START_MONTH
,      END_MONTH
,      SENIORITY
,      ANNUAL_TAX_CALC_FLAG
,      UNION_WORKER_FLAG
,      ECONOMIC_ZONE
,      TAX_SUBSIDY_PCT
,      SUBSIDY_PORTION_APPLIED
,      OTHER_ER_RFC1
,      OTHER_ER_RFC2
,      OTHER_ER_RFC3
,      OTHER_ER_RFC4
,      OTHER_ER_RFC5
,      OTHER_ER_RFC6
,      OTHER_ER_RFC7
,      OTHER_ER_RFC8
,      OTHER_ER_RFC9
,      OTHER_ER_RFC10
,      STATE_ID
,      RATE_1991_IND
,      RATE_FISCAL_YEAR_IND
,      VOLUNTARY_CONTRIBUTIONS_EE
,      VOLUNTARY_CONTRIBUTIONS_ER
,      VOLUNTARY_CONTRIBUTIONS_TOTAL
,      TOT_DED_VOL_CONTRIBUTION
,      TOT_EARNING_ASSI_CONCEPTS
,      EMPLOYEE_STATE_TAX_WITHHELD
,      TOT_EXEMPT_EARNINGS
,      TOT_NON_CUMULATIVE_EARNINGS
,      TOT_CUMULATIVE_EARNINGS
,      ISR_CALCULATED
,      ISR_CREDITABLE_SUBSIDY
,      ISR_NON_CREDITABLE_SUBSIDY
,      CREDITABLE_SUBSIDY_FRACTIONIII
,      CREDITABLE_SUBSIDY_FRACTIONIV
,      ISR_ON_CUMULATIVE_EARNINGS
,      ISR_ON_NON_CUMULATIVE_EARNINGS
,      TAX_ON_INCOME_FISCAL_YEAR
,      ISR_TAX_WITHHELD
,      RET_EARNINGS_IN_ONE_PYMNT
,      RET_EARNINGS_IN_PART_PYMNT
,      RET_DAILY_EARNINGS_IN_PYMNT
,      RET_PERIOD_EARNINGS
,      RET_EARNINGS_DAYS
,      RET_EXEMPT_EARNINGS
,      RET_TAXABLE_EARNINGS
,      RET_CUMULATIVE_EARNINGS
,      RET_NON_CUMULATIVE_EARNINGS
,      ISR_WITHHELD_FOR_RET_EARNINGS
,      AMENDS
,      ISR_EXEMPT_FOR_AMENDS
,      ISR_SUBJECT_FOR_AMENDS
,      LAST_MTH_ORD_SAL
,      LAST_MTH_ORD_SAL_WITHHELD
,      NON_CUMULATIVE_AMENDS
,      ISR_WITHHELD_FOR_AMENDS
,      ASSIMILATED_EARNINGS
,      ISR_WITHHELD_FOR_ASSI_EARNINGS
,      STK_OPTIONS_VESTING_VALUE
,      STK_OPTIONS_GRANT_PRICE
,      STK_OPTIONS_CUML_INCOME
,      STK_OPTIONS_TAX_WITHHELD
,      ISR_EXEMPT_FOR_FIXED_EARNINGS
,      ISR_SUBJECT_FOR_FIXED_EARNINGS
,      ISR_EXEMPT_FOR_XMAS_BONUS
,      ISR_SUBJECT_FOR_XMAS_BONUS
,      ISR_EXEMPT_FOR_TRAVEL_EXP
,      ISR_SUBJECT_FOR_TRAVEL_EXP
,      ISR_EXEMPT_FOR_OVERTIME
,      ISR_SUBJECT_FOR_OVERTIME
,      ISR_EXEMPT_FOR_VAC_PREMIUM
,      ISR_SUBJECT_FOR_VAC_PREMIUM
,      ISR_EXEMPT_FOR_DOM_PREMIUM
,      ISR_SUBJECT_FOR_DOM_PREMIUM
,      ISR_EXEMPT_FOR_PROFIT_SHARING
,      ISR_SUBJECT_FOR_PROFIT_SHARING
,      ISR_EXEMPT_FOR_HEALTHCARE_REI
,      ISR_SUBJECT_FOR_HEALTHCARE_REI
,      ISR_EXEMPT_FOR_SAVINGS_FUND
,      ISR_SUBJECT_FOR_SAVINGS_FUND
,      ISR_EXEMPT_FOR_SAVINGS_BOX
,      ISR_SUBJECT_FOR_SAVINGS_BOX
,      ISR_EXEMPT_FOR_PANTRY_COUPONS
,      ISR_SUBJECT_FOR_PANTRY_COUPONS
,      ISR_EXEMPT_FOR_FUNERAL_AID
,      ISR_SUBJECT_FOR_FUNERAL_AID
,      ISR_EXEMPT_FOR_WR_PD_BY_ER
,      ISR_SUBJECT_FOR_WR_PD_BY_ER
,      ISR_EXEMPT_FOR_PUN_INCENTIVE
,      ISR_SUBJECT_FOR_PUN_INCENTIVE
,      ISR_EXEMPT_FOR_LIFE_INS_PRE
,      ISR_SUBJECT_FOR_LIFE_INS_PRE
,      ISR_EXEMPT_FOR_MAJOR_MED_INS
,      ISR_SUBJECT_FOR_MAJOR_MED_INS
,      ISR_EXEMPT_FOR_REST_COUPONS
,      ISR_SUBJECT_FOR_REST_COUPONS
,      ISR_EXEMPT_FOR_GAS_COUPONS
,      ISR_SUBJECT_FOR_GAS_COUPONS
,      ISR_EXEMPT_FOR_UNI_COUPONS
,      ISR_SUBJECT_FOR_UNI_COUPONS
,      ISR_EXEMPT_FOR_RENTAL_AID
,      ISR_SUBJECT_FOR_RENTAL_AID
,      ISR_EXEMPT_FOR_EDU_AID
,      ISR_SUBJECT_FOR_EDU_AID
,      ISR_EXEMPT_FOR_GLASSES_AID
,      ISR_SUBJECT_FOR_GLASSES_AID
,      ISR_EXEMPT_FOR_TRANS_AID
,      ISR_SUBJECT_FOR_TRANS_AID
,      ISR_EXEMPT_FOR_UNION_PD_BY_ER
,      ISR_SUBJECT_FOR_UNION_PD_BY_ER
,      ISR_EXEMPT_FOR_DISAB_SUBSIDY
,      ISR_SUBJECT_FOR_DISAB_SUBSIDY
,      ISR_EXEMPT_FOR_CHILD_SCHOLAR
,      ISR_SUBJECT_FOR_CHILD_SCHOLAR
,      PREV_ER_EARNINGS
,      PREV_ER_EXEMPT_EARNINGS
,      ISR_EXEMPT_OTHER_INCOME
,      ISR_SUBJECT_OTHER_INCOME
,      TOTAL_SUBJECT_EARNINGS
,      TOTAL_EXEMPT_EARNINGS
,      TAX_WITHHELD_IN_FISCAL_YEAR
,      PREV_ER_ISR_WITHHELD
,      CURRENT_FY_ARREARS
,      PREV_FY_ARREARS
,      CREDIT_TO_SALARY
,      CREDIT_TO_SALARY_PAID
,      SOCIAL_FORESIGHT_EARNINGS
,      ISR_EXEMPT_FOR_SOC_FORESIGHT
,      AID_FOR_PANTRY_AND_FOOD
,      ISR_SUBSIDY_FOR_EMP
,      ISR_SUBSIDY_FOR_EMP_PAID
,      ISR_TAX_TO_CHARGE
FROM APPS.PAY_MX_ISR_TAX_FORMAT37_V;

Dependencies

[top of page]

APPS.PAY_MX_ISR_TAX_FORMAT37_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
SynonymPAY_ACTION_INFORMATION
SynonymPAY_ASSIGNMENT_ACTIONS
PL/SQL PackagePAY_MX_ISR_FORMAT37 - show dependent code
PL/SQL PackagePAY_MX_YEAREND_REP - show dependent code
SynonymPAY_PAYROLL_ACTIONS
APPS.PAY_MX_ISR_TAX_FORMAT37_V is referenced by following:

SchemaAPPS
Package BodyPAY_MX_DIM_MAG - show dependent code
Package BodyPAY_MX_FORMAT_2D - show dependent code
Package BodyPAY_MX_SUBSIDY_EMP_PD_RPT - show dependent code