[Home] [Help]
[Dependency Information]
| Object Name: | PAY_PAYAUTAX_PYE_ENT_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PAY.PAY_PAYAUTAX_PYE_ENT_V
PER.PAY_PAYAUTAX_PYE_ENT_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 |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
| ELEMENT_ENTRY_ID | NUMBER | (15) | Yes | |
| INPUT_VALUE_ID0 | NUMBER | (9) | Yes | |
| D_AUSTRALIAN_RESIDENT_FLAG | VARCHAR2 | (80) | ||
| AUSTRALIAN_RESIDENT_FLAG | VARCHAR2 | (1) | ||
| SENIOR_AUSTRALIAN_TYPE | VARCHAR2 | (1) | ||
| INPUT_VALUE_ID1 | NUMBER | (9) | Yes | |
| D_TAX_FREE_THRESHOLD_FLAG | VARCHAR2 | (80) | ||
| TAX_FREE_THRESHOLD_FLAG | VARCHAR2 | (60) | ||
| INPUT_VALUE_ID2 | NUMBER | (9) | Yes | |
| REBATE_AMOUNT | VARCHAR2 | (60) | ||
| D_REBATE_AMOUNT | VARCHAR2 | (60) | ||
| INPUT_VALUE_ID3 | NUMBER | (9) | Yes | |
| D_FTA_CLAIM_FLAG | VARCHAR2 | (80) | ||
| FTA_CLAIM_FLAG | VARCHAR2 | (1) | ||
| BASIS_OF_PAYMENT | VARCHAR2 | (1) | ||
| INPUT_VALUE_ID4 | NUMBER | (9) | Yes | |
| D_SAVINGS_REBATE_FLAG | VARCHAR2 | (80) | ||
| SAVINGS_REBATE_FLAG | VARCHAR2 | (60) | ||
| INPUT_VALUE_ID5 | NUMBER | (9) | Yes | |
| D_HECS_FLAG | VARCHAR2 | (80) | ||
| HECS_FLAG | VARCHAR2 | (1) | ||
| D_SFSS_FLAG | VARCHAR2 | (80) | ||
| SFSS_FLAG | VARCHAR2 | (1) | ||
| INPUT_VALUE_ID6 | NUMBER | (9) | Yes | |
| DECLARATION_SIGNED_DATE | VARCHAR2 | (60) | ||
| D_DECLARATION_SIGNED_DATE | VARCHAR2 | (60) | ||
| INPUT_VALUE_ID7 | NUMBER | (9) | Yes | |
| D_MEDICARE_LEVY_VARIATION | VARCHAR2 | (80) | ||
| MEDICARE_LEVY_VARIATION | VARCHAR2 | (60) | ||
| INPUT_VALUE_ID8 | NUMBER | (9) | Yes | |
| D_SPOUSE_FLAG | VARCHAR2 | (80) | ||
| SPOUSE_FLAG | VARCHAR2 | (1) | ||
| D_MLS_FLAG | VARCHAR2 | (80) | ||
| MLS_FLAG | VARCHAR2 | (1) | ||
| INPUT_VALUE_ID9 | NUMBER | (9) | Yes | |
| CHILDREN | VARCHAR2 | (60) | ||
| D_CHILDREN | VARCHAR2 | (60) | ||
| INPUT_VALUE_ID10 | NUMBER | (9) | Yes | |
| D_TAX_VARIATION_TYPE | VARCHAR2 | (80) | ||
| TAX_VARIATION_TYPE | VARCHAR2 | (1) | ||
| D_TAX_VARIATION_BONUS | VARCHAR2 | (80) | ||
| TAX_VARIATION_BONUS | VARCHAR2 | (1) | ||
| INPUT_VALUE_ID11 | NUMBER | (9) | Yes | |
| TAX_VARIATION_AMOUNT | VARCHAR2 | (60) | ||
| D_TAX_VARIATION_AMOUNT | VARCHAR2 | (60) | ||
| INPUT_VALUE_ID13 | NUMBER | (9) | Yes | |
| TAX_FILE_NUMBER | VARCHAR2 | (60) | ||
| D_TAX_FILE_NUMBER | VARCHAR2 | (60) | ||
| INPUT_VALUE_ID14 | NUMBER | (9) | Yes | |
| EXEMPT_FLOOD_LEVY_FLAG | VARCHAR2 | (60) | ||
| D_EXEMPT_FLOOD_LEVY_FLAG | VARCHAR2 | (60) | ||
| D_MLS_RATE | VARCHAR2 | (80) | ||
| MLS_RATE | VARCHAR2 | (1) | ||
| ASSIGNMENT_ID | NUMBER | (10) | Yes | |
| EFFECTIVE_START_DATE | DATE | Yes | ||
| EFFECTIVE_END_DATE | DATE | Yes | ||
| TFN_LAST_UPDATED_DATE | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, OBJECT_VERSION_NUMBER
, ELEMENT_ENTRY_ID
, INPUT_VALUE_ID0
, D_AUSTRALIAN_RESIDENT_FLAG
, AUSTRALIAN_RESIDENT_FLAG
, SENIOR_AUSTRALIAN_TYPE
, INPUT_VALUE_ID1
, D_TAX_FREE_THRESHOLD_FLAG
, TAX_FREE_THRESHOLD_FLAG
, INPUT_VALUE_ID2
, REBATE_AMOUNT
, D_REBATE_AMOUNT
, INPUT_VALUE_ID3
, D_FTA_CLAIM_FLAG
, FTA_CLAIM_FLAG
, BASIS_OF_PAYMENT
, INPUT_VALUE_ID4
, D_SAVINGS_REBATE_FLAG
, SAVINGS_REBATE_FLAG
, INPUT_VALUE_ID5
, D_HECS_FLAG
, HECS_FLAG
, D_SFSS_FLAG
, SFSS_FLAG
, INPUT_VALUE_ID6
, DECLARATION_SIGNED_DATE
, D_DECLARATION_SIGNED_DATE
, INPUT_VALUE_ID7
, D_MEDICARE_LEVY_VARIATION
, MEDICARE_LEVY_VARIATION
, INPUT_VALUE_ID8
, D_SPOUSE_FLAG
, SPOUSE_FLAG
, D_MLS_FLAG
, MLS_FLAG
, INPUT_VALUE_ID9
, CHILDREN
, D_CHILDREN
, INPUT_VALUE_ID10
, D_TAX_VARIATION_TYPE
, TAX_VARIATION_TYPE
, D_TAX_VARIATION_BONUS
, TAX_VARIATION_BONUS
, INPUT_VALUE_ID11
, TAX_VARIATION_AMOUNT
, D_TAX_VARIATION_AMOUNT
, INPUT_VALUE_ID13
, TAX_FILE_NUMBER
, D_TAX_FILE_NUMBER
, INPUT_VALUE_ID14
, EXEMPT_FLOOD_LEVY_FLAG
, D_EXEMPT_FLOOD_LEVY_FLAG
, D_MLS_RATE
, MLS_RATE
, ASSIGNMENT_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, TFN_LAST_UPDATED_DATE
FROM APPS.PAY_PAYAUTAX_PYE_ENT_V;
APPS
FND_SESSIONS
HR_API
- show dependent code
HR_LOOKUPS
PAY_ELEMENT_ENTRIES_F
PAY_ELEMENT_ENTRY_VALUES_F
PAY_ELEMENT_TYPES_F
PAY_INPUT_VALUES_F
APPS.PAY_PAYAUTAX_PYE_ENT_V is not referenced by any database object
|
|
|
|