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.

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

VIEW: APPS.PAY_PAYAUTAX_PYE_ENT_V

Object Details

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

* 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
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)
ASSIGNMENT_ID	NUMBER	(10)	Yes
EFFECTIVE_START_DATE	DATE		Yes
EFFECTIVE_END_DATE	DATE		Yes
TFN_LAST_UPDATED_DATE	VARCHAR2	(150)

Query Text

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
,      ASSIGNMENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      TFN_LAST_UPDATED_DATE
FROM APPS.PAY_PAYAUTAX_PYE_ENT_V;

Dependencies

[top of page]

APPS.PAY_PAYAUTAX_PYE_ENT_V references the following:

APPS: FND_GLOBAL - show dependent code; 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 referenced by following:

PUBLIC: PAY_PAYAUTAX_PYE_ENT_V