[Home] [Help]
[Dependency Information]
| Object Name: | PAY_US_STATE_ACTION_INFO_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PAY.PAY_US_STATE_ACTION_INFO_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| JURISDICTION_CODE | VARCHAR2 | (15) | ||
| JURISDICTION_NAME | VARCHAR2 | (4000) | ||
| ACTION_NUMBER | NUMBER | (15) | Yes | |
| ASSIGNMENT_ID | NUMBER | (10) | ||
| EFFECTIVE_DATE | DATE | |||
| SIT_GROSS | NUMBER | |||
| SIT_SUBJ_WHABLE | NUMBER | |||
| SIT_SUBJ_NWHABLE | NUMBER | |||
| SIT_PRE_TAX_REDNS | NUMBER | |||
| SIT_SUBJECT | NUMBER | |||
| SIT_REDUCED_SUBJECT | NUMBER | |||
| SIT_WITHHELD | NUMBER | |||
| SDI_EE_GROSS | NUMBER | |||
| SDI_EE_TAXABLE | NUMBER | |||
| SDI_EE_SUBJ_WHABLE | NUMBER | |||
| SDI_EE_PRE_TAX_REDNS | NUMBER | |||
| SDI_EE_REDUCED_SUBJECT | NUMBER | |||
| SDI_EE_WITHHELD | NUMBER | |||
| SDI_ER_GROSS | NUMBER | |||
| SDI_ER_TAXABLE | NUMBER | |||
| SDI_ER_SUBJ_WHABLE | NUMBER | |||
| SDI_ER_PRE_TAX_REDNS | NUMBER | |||
| SDI_ER_REDUCED_SUBJECT | NUMBER | |||
| SDI_ER_LIABILITY | NUMBER | |||
| SUI_EE_GROSS | NUMBER | |||
| SUI_EE_TAXABLE | NUMBER | |||
| SUI_EE_SUBJ_WHABLE | NUMBER | |||
| SUI_EE_PRE_TAX_REDNS | NUMBER | |||
| SUI_EE_REDUCED_SUBJECT | NUMBER | |||
| SUI_EE_WITHHELD | NUMBER | |||
| SUI_ER_GROSS | NUMBER | |||
| SUI_ER_TAXABLE | NUMBER | |||
| SUI_ER_SUBJ_WHABLE | NUMBER | |||
| SUI_ER_PRE_TAX_REDNS | NUMBER | |||
| SUI_ER_REDUCED_SUBJECT | NUMBER | |||
| SUI_ER_LIABILITY | NUMBER | |||
| WORKERS_COMP_WITHHELD | NUMBER | |||
| WORKERS_COMP2_WITHHELD | NUMBER | |||
| WORKERS_COMP2_ER | NUMBER | |||
| WORKERS_COMP3_ER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT JURISDICTION_CODE
, JURISDICTION_NAME
, ACTION_NUMBER
, ASSIGNMENT_ID
, EFFECTIVE_DATE
, SIT_GROSS
, SIT_SUBJ_WHABLE
, SIT_SUBJ_NWHABLE
, SIT_PRE_TAX_REDNS
, SIT_SUBJECT
, SIT_REDUCED_SUBJECT
, SIT_WITHHELD
, SDI_EE_GROSS
, SDI_EE_TAXABLE
, SDI_EE_SUBJ_WHABLE
, SDI_EE_PRE_TAX_REDNS
, SDI_EE_REDUCED_SUBJECT
, SDI_EE_WITHHELD
, SDI_ER_GROSS
, SDI_ER_TAXABLE
, SDI_ER_SUBJ_WHABLE
, SDI_ER_PRE_TAX_REDNS
, SDI_ER_REDUCED_SUBJECT
, SDI_ER_LIABILITY
, SUI_EE_GROSS
, SUI_EE_TAXABLE
, SUI_EE_SUBJ_WHABLE
, SUI_EE_PRE_TAX_REDNS
, SUI_EE_REDUCED_SUBJECT
, SUI_EE_WITHHELD
, SUI_ER_GROSS
, SUI_ER_TAXABLE
, SUI_ER_SUBJ_WHABLE
, SUI_ER_PRE_TAX_REDNS
, SUI_ER_REDUCED_SUBJECT
, SUI_ER_LIABILITY
, WORKERS_COMP_WITHHELD
, WORKERS_COMP2_WITHHELD
, WORKERS_COMP2_ER
, WORKERS_COMP3_ER
FROM APPS.PAY_US_STATE_ACTION_INFO_V;
APPS
PAY_ACTION_INFORMATION
PAY_US_EMPLOYEE_PAYSLIP_WEB
- show dependent code
APPS
PAY_ARCHIVER_REPORT_PKG
- show dependent code
PUBLIC
PAY_US_STATE_ACTION_INFO_V
|
|
|
|