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.HRDPV_UPDATE_ADI_TAX_CRP

Object Details

Object Name:	HRDPV_UPDATE_ADI_TAX_CRP
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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_HIRE_DATE	VARCHAR2	(2000)
P_LEGAL_EMPLOYER	VARCHAR2	(2000)
P_TAX_FILE_NUMBER	VARCHAR2	(2000)
P_TAX_FREE_THRESHOLD	VARCHAR2	(2000)
P_AUSTRALIAN_RESIDENT	VARCHAR2	(2000)
P_HECS	VARCHAR2	(2000)
P_SFSS	VARCHAR2	(2000)
P_LEAVE_LOADING	VARCHAR2	(2000)
P_BASIS_OF_PAYMENT	VARCHAR2	(2000)
P_DECLARATION_SIGNED_DATE	VARCHAR2	(2000)
P_MEDICARE_LEVY_SURCHARGE	VARCHAR2	(2000)
P_MEDICARE_LEVY_EXEMPTION	VARCHAR2	(2000)
P_MEDICARE_LEVY_DEP_CHILDREN	VARCHAR2	(2000)
P_MEDICARE_LEVY_SPOUSE	VARCHAR2	(2000)
P_TAX_VARIATION_TYPE	VARCHAR2	(2000)
P_TAX_VARIATION_AMOUNT	VARCHAR2	(2000)
P_TAX_VARIATION_BONUS	VARCHAR2	(2000)
P_REBATE_AMOUNT	VARCHAR2	(2000)
P_SAVINGS_REBATE	VARCHAR2	(2000)
P_FTB_CLAIM	VARCHAR2	(2000)
P_SENIOR_AUSTRALIAN	VARCHAR2	(2000)
P_EXEMPT_FLOOD_LEVY	VARCHAR2	(2000)
P_MLS_RATE	VARCHAR2	(2000)
P_EFFECTIVE_DATE	VARCHAR2	(2000)
P_ASSIGNMENT_USER_KEY	VARCHAR2	(2000)
P_PAYROLL_NAME	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_HIRE_DATE
,      P_LEGAL_EMPLOYER
,      P_TAX_FILE_NUMBER
,      P_TAX_FREE_THRESHOLD
,      P_AUSTRALIAN_RESIDENT
,      P_HECS
,      P_SFSS
,      P_LEAVE_LOADING
,      P_BASIS_OF_PAYMENT
,      P_DECLARATION_SIGNED_DATE
,      P_MEDICARE_LEVY_SURCHARGE
,      P_MEDICARE_LEVY_EXEMPTION
,      P_MEDICARE_LEVY_DEP_CHILDREN
,      P_MEDICARE_LEVY_SPOUSE
,      P_TAX_VARIATION_TYPE
,      P_TAX_VARIATION_AMOUNT
,      P_TAX_VARIATION_BONUS
,      P_REBATE_AMOUNT
,      P_SAVINGS_REBATE
,      P_FTB_CLAIM
,      P_SENIOR_AUSTRALIAN
,      P_EXEMPT_FLOOD_LEVY
,      P_MLS_RATE
,      P_EFFECTIVE_DATE
,      P_ASSIGNMENT_USER_KEY
,      P_PAYROLL_NAME
FROM APPS.HRDPV_UPDATE_ADI_TAX_CRP;

Dependencies

[top of page]

APPS.HRDPV_UPDATE_ADI_TAX_CRP references the following:

APPS: HR_PUMP_BATCH_LINES

APPS.HRDPV_UPDATE_ADI_TAX_CRP is not referenced by any database object