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


VIEW: APPS.HRDPV_CREATE_AC_EMPTAXRULE

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes
BATCH_LINE_ID NUMBER (15) Yes
API_MODULE_ID NUMBER (15) Yes
LINE_STATUS VARCHAR2 (1) Yes
USER_SEQUENCE NUMBER (15)
LINK_VALUE NUMBER (15)
BUSINESS_GROUP_NAME VARCHAR2 (240)
P_BUSINESS_GROUP VARCHAR2 (2000)
P_EFFECTIVE_DATE VARCHAR2 (2000)
P_EMPLOYEE VARCHAR2 (2000)
P_ASSIGNMENT VARCHAR2 (2000)
P_LEGISLATION VARCHAR2 (2000)
P_SPREADSHEET_IDENTIFIER VARCHAR2 (2000)
P_SUI_STATE VARCHAR2 (2000)
P_STATE_PROV_CODE VARCHAR2 (2000)
P_COUNTY VARCHAR2 (2000)
P_CITY VARCHAR2 (2000)
P_OVERRIDE_PROV_OF_EMPLT VARCHAR2 (2000)
P_BASIC_AMT_FLAG VARCHAR2 (2000)
P_BASIC_AMT VARCHAR2 (2000)
P_TAX_CREDIT VARCHAR2 (2000)
P_FILING_STATUS_CODE VARCHAR2 (2000)
P_ALLOWANCES VARCHAR2 (2000)
P_ADDITIONAL_TAX VARCHAR2 (2000)
P_SECONDARY_ALLOWANCES VARCHAR2 (2000)
P_EXEMPTION_AMT VARCHAR2 (2000)
P_SIT_OPTIONAL_CALC_IND VARCHAR2 (2000)
P_ADDTL_ALLOWANCE_RATE VARCHAR2 (2000)
P_PRES_ZONE_DEDN VARCHAR2 (2000)
P_TAX_EXEMPT1 VARCHAR2 (2000)
P_TAX_EXEMPT2 VARCHAR2 (2000)
P_TAX_EXEMPT3 VARCHAR2 (2000)
P_TAX_EXEMPT4 VARCHAR2 (2000)
P_OVERRIDE_RATE VARCHAR2 (2000)
P_OVERRIDE_AMOUNT VARCHAR2 (2000)
P_OVERRIDE_SUPP_RATE VARCHAR2 (2000)
P_ANNUAL_DEDN VARCHAR2 (2000)
P_LABOR_FUND_CONTR VARCHAR2 (2000)
P_ALLOWANCE_REJECT_DATE VARCHAR2 (2000)
P_EIC_FILING_STATUS VARCHAR2 (2000)
P_STATUTORY_EMPLOYEE VARCHAR2 (2000)
P_CUMULATIVE_TAXATION VARCHAR2 (2000)
P_NON_RESIDENT VARCHAR2 (2000)
P_SUI_BASE_OVERRIDE_AMOUNT VARCHAR2 (2000)
P_SCHOOL_DISTRICT VARCHAR2 (2000)
P_COMM_RENUMERATION VARCHAR2 (2000)
P_COMM_EXPENSES VARCHAR2 (2000)
P_SPOUSE_OR_EQUIVALENT VARCHAR2 (2000)
P_DISABILITY_STATUS VARCHAR2 (2000)
P_NUMBER_OF_DEPENDENTS VARCHAR2 (2000)
P_NUMBER_OF_INFIRM_DEPENDENTS VARCHAR2 (2000)
P_STA_INFORMATION_CATEGORY VARCHAR2 (2000)
P_STA_INFORMATION1 VARCHAR2 (2000)
P_STA_INFORMATION2 VARCHAR2 (2000)
P_STA_INFORMATION3 VARCHAR2 (2000)
P_STA_INFORMATION4 VARCHAR2 (2000)
P_STA_INFORMATION5 VARCHAR2 (2000)
P_STA_INFORMATION6 VARCHAR2 (2000)
P_STA_INFORMATION7 VARCHAR2 (2000)
P_STA_INFORMATION8 VARCHAR2 (2000)
P_STA_INFORMATION9 VARCHAR2 (2000)
P_STA_INFORMATION10 VARCHAR2 (2000)
P_STA_INFORMATION11 VARCHAR2 (2000)
P_STA_INFORMATION12 VARCHAR2 (2000)
P_STA_INFORMATION13 VARCHAR2 (2000)
P_STA_INFORMATION14 VARCHAR2 (2000)
P_STA_INFORMATION15 VARCHAR2 (2000)
P_STA_INFORMATION16 VARCHAR2 (2000)
P_STA_INFORMATION17 VARCHAR2 (2000)
P_STA_INFORMATION18 VARCHAR2 (2000)
P_STA_INFORMATION19 VARCHAR2 (2000)
P_STA_INFORMATION20 VARCHAR2 (2000)
P_STA_INFORMATION21 VARCHAR2 (2000)
P_STA_INFORMATION22 VARCHAR2 (2000)
P_STA_INFORMATION23 VARCHAR2 (2000)
P_STA_INFORMATION24 VARCHAR2 (2000)
P_STA_INFORMATION25 VARCHAR2 (2000)
P_STA_INFORMATION26 VARCHAR2 (2000)
P_STA_INFORMATION27 VARCHAR2 (2000)
P_STA_INFORMATION28 VARCHAR2 (2000)
P_STA_INFORMATION29 VARCHAR2 (2000)
P_STA_INFORMATION30 VARCHAR2 (2000)
P_CA_TAX_INFORMATION_CATEGORY VARCHAR2 (2000)
P_CA_TAX_INFORMATION1 VARCHAR2 (2000)
P_CA_TAX_INFORMATION2 VARCHAR2 (2000)
P_CA_TAX_INFORMATION3 VARCHAR2 (2000)
P_CA_TAX_INFORMATION4 VARCHAR2 (2000)
P_CA_TAX_INFORMATION5 VARCHAR2 (2000)
P_CA_TAX_INFORMATION6 VARCHAR2 (2000)
P_CA_TAX_INFORMATION7 VARCHAR2 (2000)
P_CA_TAX_INFORMATION8 VARCHAR2 (2000)
P_CA_TAX_INFORMATION9 VARCHAR2 (2000)
P_CA_TAX_INFORMATION10 VARCHAR2 (2000)
P_CA_TAX_INFORMATION11 VARCHAR2 (2000)
P_CA_TAX_INFORMATION12 VARCHAR2 (2000)
P_CA_TAX_INFORMATION13 VARCHAR2 (2000)
P_CA_TAX_INFORMATION14 VARCHAR2 (2000)
P_CA_TAX_INFORMATION15 VARCHAR2 (2000)
P_CA_TAX_INFORMATION16 VARCHAR2 (2000)
P_CA_TAX_INFORMATION17 VARCHAR2 (2000)
P_CA_TAX_INFORMATION18 VARCHAR2 (2000)
P_CA_TAX_INFORMATION19 VARCHAR2 (2000)
P_CA_TAX_INFORMATION20 VARCHAR2 (2000)
P_CA_TAX_INFORMATION21 VARCHAR2 (2000)
P_CA_TAX_INFORMATION22 VARCHAR2 (2000)
P_CA_TAX_INFORMATION23 VARCHAR2 (2000)
P_CA_TAX_INFORMATION24 VARCHAR2 (2000)
P_CA_TAX_INFORMATION25 VARCHAR2 (2000)
P_CA_TAX_INFORMATION26 VARCHAR2 (2000)
P_CA_TAX_INFORMATION27 VARCHAR2 (2000)
P_CA_TAX_INFORMATION28 VARCHAR2 (2000)
P_CA_TAX_INFORMATION29 VARCHAR2 (2000)
P_CA_TAX_INFORMATION30 VARCHAR2 (2000)
P_ADDITIONAL_INFO1 VARCHAR2 (2000)
P_ADDITIONAL_INFO2 VARCHAR2 (2000)
P_ADDITIONAL_INFO3 VARCHAR2 (2000)
P_ADDITIONAL_INFO4 VARCHAR2 (2000)
P_ADDITIONAL_INFO5 VARCHAR2 (2000)
P_ADDITIONAL_INFO6 VARCHAR2 (2000)
P_ADDITIONAL_INFO7 VARCHAR2 (2000)
P_ADDITIONAL_INFO8 VARCHAR2 (2000)
P_ADDITIONAL_INFO9 VARCHAR2 (2000)
P_ADDITIONAL_INFO10 VARCHAR2 (2000)
Query Text

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


SELECT BATCH_ID
,      BATCH_LINE_ID
,      API_MODULE_ID
,      LINE_STATUS
,      USER_SEQUENCE
,      LINK_VALUE
,      BUSINESS_GROUP_NAME
,      P_BUSINESS_GROUP
,      P_EFFECTIVE_DATE
,      P_EMPLOYEE
,      P_ASSIGNMENT
,      P_LEGISLATION
,      P_SPREADSHEET_IDENTIFIER
,      P_SUI_STATE
,      P_STATE_PROV_CODE
,      P_COUNTY
,      P_CITY
,      P_OVERRIDE_PROV_OF_EMPLT
,      P_BASIC_AMT_FLAG
,      P_BASIC_AMT
,      P_TAX_CREDIT
,      P_FILING_STATUS_CODE
,      P_ALLOWANCES
,      P_ADDITIONAL_TAX
,      P_SECONDARY_ALLOWANCES
,      P_EXEMPTION_AMT
,      P_SIT_OPTIONAL_CALC_IND
,      P_ADDTL_ALLOWANCE_RATE
,      P_PRES_ZONE_DEDN
,      P_TAX_EXEMPT1
,      P_TAX_EXEMPT2
,      P_TAX_EXEMPT3
,      P_TAX_EXEMPT4
,      P_OVERRIDE_RATE
,      P_OVERRIDE_AMOUNT
,      P_OVERRIDE_SUPP_RATE
,      P_ANNUAL_DEDN
,      P_LABOR_FUND_CONTR
,      P_ALLOWANCE_REJECT_DATE
,      P_EIC_FILING_STATUS
,      P_STATUTORY_EMPLOYEE
,      P_CUMULATIVE_TAXATION
,      P_NON_RESIDENT
,      P_SUI_BASE_OVERRIDE_AMOUNT
,      P_SCHOOL_DISTRICT
,      P_COMM_RENUMERATION
,      P_COMM_EXPENSES
,      P_SPOUSE_OR_EQUIVALENT
,      P_DISABILITY_STATUS
,      P_NUMBER_OF_DEPENDENTS
,      P_NUMBER_OF_INFIRM_DEPENDENTS
,      P_STA_INFORMATION_CATEGORY
,      P_STA_INFORMATION1
,      P_STA_INFORMATION2
,      P_STA_INFORMATION3
,      P_STA_INFORMATION4
,      P_STA_INFORMATION5
,      P_STA_INFORMATION6
,      P_STA_INFORMATION7
,      P_STA_INFORMATION8
,      P_STA_INFORMATION9
,      P_STA_INFORMATION10
,      P_STA_INFORMATION11
,      P_STA_INFORMATION12
,      P_STA_INFORMATION13
,      P_STA_INFORMATION14
,      P_STA_INFORMATION15
,      P_STA_INFORMATION16
,      P_STA_INFORMATION17
,      P_STA_INFORMATION18
,      P_STA_INFORMATION19
,      P_STA_INFORMATION20
,      P_STA_INFORMATION21
,      P_STA_INFORMATION22
,      P_STA_INFORMATION23
,      P_STA_INFORMATION24
,      P_STA_INFORMATION25
,      P_STA_INFORMATION26
,      P_STA_INFORMATION27
,      P_STA_INFORMATION28
,      P_STA_INFORMATION29
,      P_STA_INFORMATION30
,      P_CA_TAX_INFORMATION_CATEGORY
,      P_CA_TAX_INFORMATION1
,      P_CA_TAX_INFORMATION2
,      P_CA_TAX_INFORMATION3
,      P_CA_TAX_INFORMATION4
,      P_CA_TAX_INFORMATION5
,      P_CA_TAX_INFORMATION6
,      P_CA_TAX_INFORMATION7
,      P_CA_TAX_INFORMATION8
,      P_CA_TAX_INFORMATION9
,      P_CA_TAX_INFORMATION10
,      P_CA_TAX_INFORMATION11
,      P_CA_TAX_INFORMATION12
,      P_CA_TAX_INFORMATION13
,      P_CA_TAX_INFORMATION14
,      P_CA_TAX_INFORMATION15
,      P_CA_TAX_INFORMATION16
,      P_CA_TAX_INFORMATION17
,      P_CA_TAX_INFORMATION18
,      P_CA_TAX_INFORMATION19
,      P_CA_TAX_INFORMATION20
,      P_CA_TAX_INFORMATION21
,      P_CA_TAX_INFORMATION22
,      P_CA_TAX_INFORMATION23
,      P_CA_TAX_INFORMATION24
,      P_CA_TAX_INFORMATION25
,      P_CA_TAX_INFORMATION26
,      P_CA_TAX_INFORMATION27
,      P_CA_TAX_INFORMATION28
,      P_CA_TAX_INFORMATION29
,      P_CA_TAX_INFORMATION30
,      P_ADDITIONAL_INFO1
,      P_ADDITIONAL_INFO2
,      P_ADDITIONAL_INFO3
,      P_ADDITIONAL_INFO4
,      P_ADDITIONAL_INFO5
,      P_ADDITIONAL_INFO6
,      P_ADDITIONAL_INFO7
,      P_ADDITIONAL_INFO8
,      P_ADDITIONAL_INFO9
,      P_ADDITIONAL_INFO10
FROM APPS.HRDPV_CREATE_AC_EMPTAXRULE;

Dependencies

[top of page]

APPS.HRDPV_CREATE_AC_EMPTAXRULE references the following:

SchemaAPPS
SynonymHR_PUMP_BATCH_LINES

APPS.HRDPV_CREATE_AC_EMPTAXRULE is not referenced by any database object